This sounds awful, data in a completely different format every time.

The generating app probably starts with a table of some sort. Maybe you can talk them into giving you an extract of the table behind the report in .xls or .prn or delimited ascii.


>There are patterns at times but for the most part there isn't. The length of the data changes as in $5.00 and $50000.00. There are some data elements that stay the same such as the ID number but even these change lenght according to which merchant I pull a report for.