Importing data from a Print file.

I have a bit of what I think is a unique issue and I have been browsing the interwebs for the past few days in search of an answer however I have come up with nothing. I am hoping that someone hear can shed some light.

My reports @ work come from a database however I only have access to them in 2 formats. 1. Printed on Green bar. 2. Printed to a .txt file.

I need the data import the data into excel but have yet to find a solution. As you will see the data is very nicely formatted however it contains no delimiters making this quite the challenge. Any help or insight anyone can provide is much appreciated.

Thanks
Focusedonsound

Please Login or Register  to view this content.

JBeaucaire,

I have re-entered additional data. Obviously I would like to say that ALL this data is important to me. However the following data is most important.

1. Item Number
2. Status
3. Total Hand
4. Back Orders (With the weeks layout)
5. Recent Sales (With the weeks layout)
4. All of the Sales History. This is an actual sales record what you are seeing is REAL!

As you can see. Being this is a printed report its one record after the next. So you will see in this example Item Number: 97896BLKL followed by 97896BLKM which then MAY or MAY not be followed by 97896BLKS it can be directly followed by any item. This example just so happens to show the next size.

Please Login or Register  to view this content.

M32Example.xls

Please find attached a general idea on how this should lay out into a spreadsheet.

Please let me know if more information is needed.

Regards
Focusedonsound

Can anyone please give me some insight?