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...