Hello all, thank you for taking the time to read and/or reply!
I have been charged with writing a macro that will parse a somewhat messy text file automatically generated by a program in search of a few values. All of the fields are listed first, i.e.: “Invoice Number Payment Delivery Method Expiration Date etc.” (all separated by tabs) and the actual values for each field are listed at the end in the same respective order (i.e.: 3487242 USPS 10/13/2011 etc.” . I only need a few of the values out of all this information, but can’t figure out a clean way to do it without being so convoluted as to make the macro insanely long. Any help would be greatly appreciated!
Thank you.