Any help on getting the following data parsed? Please note that the space between the items is not equal, output will have six column and the last item in the last row (29.01) should go to the last cell of resultant table (in same column as 1461.811).
7-030 FLAT-YTO/BUNNY 25 492.374 1,232.382 8,049.505 |
8-011 SQUARE-FRUITY-LEVEL 26 939.90 8,140.686 1,461.811 |
9-02 ROUND-COMPN SERVICE 27 29.01 |
What would you like the output to look like?