After several attempts, I am in need of some expert help parsing lines of text w/ VB6 Pro. Here's the scenario: It starts with an Excel sheet which is an export from a Peachtree accounting app. I have taken the Excel file and made a text file from it with many hundreds of long lines.
Each item is made up of anywhere from 8 to 10 of these lines. There's no key field with unique data that can be anticipated. The first 7 characters of each line (in the first tab field) make up the item number, which are what I would, in effect, like to use as a key. There is string data on several other lines that I need to extract and associate with the item no.
I think I need to loop through line inputs, checking for an item no. match with my search string. Next, If there's an InStr match, I need to check the line for substring labels that I know will preceed the data I need to get.
For example, if the second line has the string "Size:" in it, I know how to grab the size that follows, or if "Serial #::, how to get the serial number that follows.
The problem is that the size can be on any line, and the serial number can be on any other line.
None of this, however, seems to be working for me...Has anyone done this sort of thing before? Any ideas?