Missing commas after Excel Converts to CSV format (Delimiter)
Posted on 2003-03-24
I have save an excel file as a CSV file. Out of 11 columns, 8 are occupied with data. The CSV file would reflect:
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.
Perhaps you can try on any excel file and see what I mean.
Is this a known problem? What should I do? I need the commas reflected in the CSV file. Right now, I have to do it manually on each converted CSV file, by typing ,,, 17th line onwards.
Can I create a VBA programme or other language to read the file and input the three commas?