Reading data for CSV generates ',' for last column

[Anonymous]

Dear All,

I am trying to load data from a CSV file that has 6 columns. When I look at the File Wizard, the last column has a comma (',') appended to the column title as well as all the column values. This happens only to the last column.

Even if I trying changing the Characterset to UTF-8 or other format, the commas are still present.

I do not see these commas in the source CSV file. Can someone let me know why these commas do occur in the data when they are absent in source data ?

[Gysbert_Wassenaar]

Can you post the csv file? Or a file that contains some lines from it?

If all fails you could always remove the last comma with one of these options:

purgechar(MyField, ',') as MyField

left(MyField,len(MyField)-1) as MyField

subfield(MyField, ',' ,-1) as MyField

[Peter_Cammaert]

Can you post part of the original CSV?

The import uses semicolons as separators, so I would think that the comma's are present in your input data...

[awhitfield]

From the screen shot it  you have 'Delimiter' set as semi colon ; when it should be comma ,

Andy