Parsing text files - how to import

[MrTibbs]

I have a text file (a dump of a Unix system report) which I need to import.
The file has several lines which can be discarded and relevant information about an item split between multiple lines e.g.
Item Number: fred Gll+Bulk
Past 12/11/01 19/11/01 Gross Reqs 0 40320 0160

These are the lines I want to import for item fred (they are actually lots of columns wide).
I can determine the lines required but can't use Transfertext because the lines are not formatted the same way.
I may pass the lines out to a text file and then re-import them using transfertext.
Anyone know a better way to parse selected lines into a table?

 

[Travis]

My first answer (Which will cost $) would be to get MONARCH, this application is designed for just this situation.

My Second answer would be to use the OPEN function to read the lines in one at a time parsing for the data that you want for each record using an append/update query to add the information to the table.