topic Re: Reading data for CSV generates ',' for last column in QlikView

Reading data for CSV generates ',' for last column

Anonymous — Thu, 05 Mar 2015 13:31:55 GMT

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 ?

Re: Reading data for CSV generates ',' for last column

Gysbert_Wassenaar — Thu, 05 Mar 2015 13:38:09 GMT

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

Re: Reading data for CSV generates ',' for last column

Peter_Cammaert — Thu, 05 Mar 2015 13:40:09 GMT

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...

Re: Reading data for CSV generates ',' for last column

awhitfield — Thu, 05 Mar 2015 14:38:48 GMT

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

Andy