I normally read files like this one line at a time into a single note field. Read the header line out, Then read the following records and parse them out and put the results into another table.
Troy -----Original Message----- From: John Shaw [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 8:11 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: [OT] Extract data from report Hello all, This is way off topic and not even web related, so stop reading if you don't want to waste your time on it. A legacy system, which I have no control over, provides a huge text file with about a hundred separate fixed-length batches. The frustrating thing is that they could have combined into one file, but they divided it up and put the value that distinguishes each batch in a header. So it has a heading, then a report, then a heading, etc. The only way to do anything with the data is to extract the value from the header and then combine it with the subsequent rows. Does anyone know of a product that can extract data from a text file like that and put it in a useable form? Thanks. John ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
