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

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.

"Jeff" wrote:

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

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

Thanks!

"dlw" wrote:

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.

"Jeff" wrote:

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