Software

Ask something
Discussion Locked

Commas in CSV File (Delimiter) From XLS

0 helpful
3 replies

by crispin_yuen

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello

I have save an excel file as a CSV file. Out of 11 columns, 8 are occupied with data. The CSV file would reflect:

Column1Data,Column2Data,Column3Data,Column4Data,Column5Data,Column6Data,Column7Data,Column8Data,,,

The last three commas denotes the last three columns that have no data. However, the last three commas are shown only till the 16th line. It happens on other excel file converted to CSV format.

Can I create a VBA programme or other language to read the file and inputthe three commas?

Pls advise. Thank you.

3 replies

by sgt_shultz

well. is this something you will be doing over and over again? or just one time?
this sounds like a bug in Excel. are you using the latest service packs? can you try another version of Excel to see if the problem is in other versions as well? i have no experience with that bug but if i were doing this I would see if I could get a tab delimited file instead of comma delimited. maybe it would be better behaved?
as far as visual basic, i would make a Word macro to do this...or, download TextPad and make a macro to do same... check out 'regular expressions' under TextPad help...

by crispin_yuen

Thank you for your reply. I've tried to add a space in the last cell of the sheet. When I opened up, all the commas were shown. But, I don't understand why Excel has this kind of bug. Can it be resolve?

This discussion is closed to new replies.