3 Replies Latest reply: Mar 5, 2015 9:38 AM by andy whitfield RSS

    Reading data for CSV generates ',' for last column

    Aushik Makdoom

      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 ?