Dos batch file

[billgilmer]

I am trying to retrieve data from a binary text file and import to a CSV file. I have over 100 storeinv files each week and I want to use this information in an excel file.
I can open the file in excel but each line is one cell.
ray:
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.

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¦
+------+-----------------------------+------+--+------+--¦




[/code] ray:

 

[jdc]

Hi

This solution will still need some manual correction, after you have opened your text file in excel you can convert it from "Text to Columns" from the Data menu.

If you add "¦" as a separator and play with the other options, you'll be able to make it a bit tidier.

As you're text's formatting may well be lost or different to what was posted, I couldn't say for certain, however post me your email address in a private message and if you want, I might be able to do some code using searching for strings and see what that comes up with.

HTH

John