"Cleaning" a text file
Posted on 2003-02-20
I have a text file that is essentially the output from an application reporting system. I need to take the contents of the text file, and erase the headers, and some other data, and then load the data into a Microsoft Access database. The problem is that the data is not separated by commas, or anything, it's just tab delimited. Also the report contains report, and page headers throughout the document that need to be removed before it's loaded into the Access database.
I need to rip away the unneed text, and load the useful text into an access database.
Ideas on how I can do this??