General discussion
March 23, 2003 at 05:53 PM
crispin_yuen

Commas in CSV File (Delimiter) From XLS

by crispin_yuen . Updated 23 years, 2 months ago

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.

This discussion is locked

All Comments