billgilmer
New Member
- Joined
- Dec 30, 2004
- Messages
- 11
I am trying to retrieve data from a dos binary text file and import to a Excel file. I have over 100 storeinv files each week and I want to use this information in an another excel file.
I can open the file in excel but each line is one cell and the informaton is text only.
The file name is
STOREINV.TXT
The info I want to retrive is The Store number, Invoice: Number
Invoice Date:, Total Net Rentals amount, Subtotals, and Minus & Voids.
Example of invoice sheet:
499 S. Phoenix
New Storessss, Texas 77777
(321) 521-6428
TO: 1111 Documenr Invoice: 11943
3826 ###AM$$$ SCHOOL RD. Date: 12/27/04
3333 444444 TX 86111
+--------------------------------------------------------+
¦AMOUNT¦ DESCRIPTION ¦UNIT COST¦ TOTAL ¦
+------+-----------------------------+---------+---------¦
¦ ¦ Total Net Rentals for ¦ ¦ ¦ 1,278¦58¦
+------+-----------------------------+------+--+------+--¦
¦ ¦ 12/17/04 thru 12/23/04 days ¦ ¦ ¦ ¦ ¦
+------+-----------------------------+------+--+------+--¦
¦ ¦ Plus Manual Contracts ¦ ¦ ¦ 0¦00¦
+------+-----------------------------+------+--+------+--¦
¦ ¦ Minus Voids ¦ ¦ ¦ 33¦49¦
+------+-----------------------------+------+--+------+--¦
¦ ¦ Subtotal ¦ ¦ ¦ 1,245¦09¦
+------+-----------------------------+------+--+------+--¦
I can open the file in excel but each line is one cell and the informaton is text only.
The file name is
STOREINV.TXT
The info I want to retrive is The Store number, Invoice: Number
Invoice Date:, Total Net Rentals amount, Subtotals, and Minus & Voids.
Example of invoice sheet:
499 S. Phoenix
New Storessss, Texas 77777
(321) 521-6428
TO: 1111 Documenr Invoice: 11943
3826 ###AM$$$ SCHOOL RD. Date: 12/27/04
3333 444444 TX 86111
+--------------------------------------------------------+
¦AMOUNT¦ DESCRIPTION ¦UNIT COST¦ TOTAL ¦
+------+-----------------------------+---------+---------¦
¦ ¦ Total Net Rentals for ¦ ¦ ¦ 1,278¦58¦
+------+-----------------------------+------+--+------+--¦
¦ ¦ 12/17/04 thru 12/23/04 days ¦ ¦ ¦ ¦ ¦
+------+-----------------------------+------+--+------+--¦
¦ ¦ Plus Manual Contracts ¦ ¦ ¦ 0¦00¦
+------+-----------------------------+------+--+------+--¦
¦ ¦ Minus Voids ¦ ¦ ¦ 33¦49¦
+------+-----------------------------+------+--+------+--¦
¦ ¦ Subtotal ¦ ¦ ¦ 1,245¦09¦
+------+-----------------------------+------+--+------+--¦