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

ITEM NUMBER: 97896BERL      (11658523)                                                  AS OF FRI, DEC 19, 2008,  8:25 AM <ITEMSALE>
 WAREHOUSE LOCAL
 STATUS: CANCELED          DESC:  JACKET MNS                                      PRODUCT CLASS:           CATEGORY:     0L00
  ALT #:           VEND MODEL #:                            PURCH PACK SIZE:   0                 PACK:       1     WEIGHT:    1.740

              NOMINAL LT: 3  NOMINAL RP:       4  CALC RP:       4  TOTAL HAND:       0  FUTURE ORDERS:       0

                                                                                   TOTAL      1 WK     2 WKS     3 WKS OVER 3WKS
                       LOC CAP:       0     LOC RESTOCK:         0
     TRUE BO:       0  PRIMARY:       0                           BACK ORDERS:         0         0         0         0         0
 INDIRECT BO:       0     BULK:       0                           RECENT SALE:         0         0         0         0         0


                                                   S A L E S    H I S T O R Y

     ****************** 08 ***************** ******************** 07 *************** ******************* 06 ****************
       ST #1   ST #2   ST #3 ST #4,5   TOTAL   ST #1   ST #2   ST #3 ST #4,5   TOTAL   ST #1   ST #2   ST #3 ST #4,5   TOTAL
  1        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
  2        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
  3        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
  4        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
  5        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
  6        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
  7        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
  8        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
  9        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
 10        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
 11        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
 12        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0
 **        0       0       0       0       0       0       0       0       0       0       0       0       0       0       0


                                                 P U R C H A S E   H I S T O R Y

 VEND  MODEL #        ORDER FROM                     SALESMAN                     TERMS DAYS TERMS % FRGHT  PREPAID ON   FRGHT

 4634-88036BERL       XXXXXXXXXXXXXXXX                                        SEE GI                   FOB FACTORY
   AA**  ATT: CXXX PXXXXX EXT XXXXX                                 CI**  XXXXXXXXXXXXX ext. XXXXX
   GI**  CUSTOMER SERVICE FAX 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -