Writing to csv

G

Guest

Hi,

I am writing data to a csv. There are 3 columns.

I want the csv output to look like this (without a comma after the last
column data)

Column1 Column2 Column3
data,data2,data3
data,data2,data3
.......

But the csv looks like
data,data2,data3,
data,data2,data3,

Thanks for your help
 
G

Guest

Excel doesn't normally do that. There must be something in the 4th column
that is causing the comma after the 3rd one. Maybe right that column in the
sheet and delete it to make sure there is nothing there.
 
G

Guest

Yes - I see now - I had a "Comma" after the last piece of data - when I
remove it it works

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top