Hello Everyone,
I am doing an extract of data into an .xls format.
Then I have to save as to a .csv to convert into a format that can be uploaded onto a web site.
But... as you can see below the first row has only 3 field but when I SAVE AS to a .csv it adds extra commas
This is affecting the web site we upload to as the parsing tool cannot read first row with the extra commas.
The other rows with extra commas are ignored and are not an issue.
First row after save as to a .csv:
VER,3.0,266XF,,,,,,,
need it as:
VER,3.0,266XF
I have figured out that the number of columns determines the number of commas in EACH row.
I have 3 rows. 1st has 3 columns, 2nd has 5 columns of data, and the 3rd has 10 columns of data.
Based on info from Excel Forum since the 3rd column has 10 columns, when you create the .csv ALL rows will have 10 comma's
Hence that is why the 1st column has 10 columns of comma's but only the first 3 have data.
Is there a way around this to stop these extra comma's when saving as a .CSV file?
our Web application that uploads this .csv file will NOT parse the 1st row with the extra comma's
Don't want to train our staff to edit and delete the comma's if I can get this done beforehand.
Is there anything I can do in Excel BEFORE I save as a .csv file to prevent the creation of the extra commas?
Let me know. thank you.
Bookmarks