I have many large files that contain data like the below example. I would like to get some input on the best way to parse these files so that each part of the data (item number, description, price, etc) can be separated and then packed into an excel file (where the item number would be in like cell A1 then the description in cell A2).
Just fishing for some ideas on what the most efficient way of doing this may be.
1 1 020-140 CS 26 X 36 REG BLK GARBAGE BAG 12.80 YY 12.80 13-E1-04 250/CASE 91/SK
1 1 375-590 PC MA612 12"BLUE HD PLST.DUSTPAN 2.30 YY 2.30 18-C2-02 EACH (12PCS/CS MA612)