Saving an Excel File as a Csv File then a txt file issue

[interwoven]

Hi everyone,

I have a 12000 line spreadsheet I need get into comma separated and it has several fields with leading zeros. So far I've gotten very close in what I need but I have one final issue I can't seem to track down. I save the file as a csv file then change the file extension to .txt and it does save my leading zeros. About 15 lines into the .txt file though it cuts off the blank cells on the end like this:

number,nlevel,supplier,quantity,buydesc,equiv,unit_price,discount,dropship,mixgroup,buydesc2,lead_avg,lead_count,changed_by,instruct1,instruct2,instruct3,volume,weight
A108NVY OFADS,2,0001,1,,1,9.5,,T,,,,,,,,,,
A108RED OFADS,2,0001,1,,1,9.5,,T,,,,,,,,,,
A122BLK LRGDS,2,0001,1,,1,12.5,,T,,,,,,,,,,
A122BLK MEDDS,2,0001,1,,1,12.5,,T,,,,,,,,,,
A122BLK SMLDS,2,0001,1,,1,12.5,,T,,,,,,,,,,
A122BLK XLGDS,2,0001,1,,1,12.5,,T,,,,,,,,,,
A136BLK LRGDS,2,0001,1,,1,4,,T,,,,,,,,,,
A136BLK XLGDS,2,0001,1,,1,4,,T,,,,,,,,,,
A136DKB LRGDS,2,0001,1,,1,4,,T,,,,,,,,,,
A136DKB XLGDS,2,0001,1,,1,4,,T,,,,,,,,,,
A136HGY LRGDS,2,0001,1,,1,4,,T,,,,,,,,,,
A136HGY XLGDS,2,0001,1,,1,4,,T,,,,,,,,,,
A136WHT LRGDS,2,0001,1,,1,4,,T,,,,,,,,,,
A136WHT XLGDS,2,0001,1,,1,4,,T,,,,,,,,,,
A140BLM LRGDS,2,0001,1,,1,11.5,,T,,,,,,,,,,
A140BLM MEDDS,2,0001,1,,1,11.5,,T
A140BLM XLGDS,2,0001,1,,1,11.5,,T
A142CHH LRGDS,2,0001,1,,1,6.5,,T
A142CHH XLGDS,2,0001,1,,1,6.5,,T
A142HGY LRGDS,2,0001,1,,1,6.5,,T
A142HGY XLGDS,2,0001,1,,1,6.5,,T
A142NVY LRGDS,2,0001,1,,1,6.5,,T
A142NVY XLGDS,2,0001,1,,1,6.5,,T
A142RPE LRGDS,2,0001,1,,1,6.5,,T

It then continues all the way down to the end. I have another sheet with many more blank cells at the end and it does this also on it but there are about 35 blank cells at the end of each row.

Any thoughts on what I am doing wrong?

Thanks!

 

[neditheg]

i'm not very sure if I understood ur problem ... .
but try to save ur file from excel in the ".prn" format ... then open it with notepad ... save it as .txt ...