28 Replies Latest reply: Sep 27, 2016 2:02 PM by Gilberto Souza RSS

    unable to load in comma delimiter csv file correctly

    Jim Chan

      Hi guys,

       

      I have a comma delimiter csv file. after I have loaded in. Some of the data in columns not aligned, some shift 1 column to the left, some shifted 1 column to the right.

       

      I have attached the .csv file.  i have use comma delimiter when loading in. but yet , still not able to get the data. how to solve it?

       

       

      error1.jpg

      As I seelcted "2015" which are not suppose to be in column_full field, found out that the data in column_h has apostrophe( ' ) symbol.

       

      But when i viewed in excel program, the rows and columns look fine.

       

      why csv delimiter cannot handle special symbol like apostrophe (‘). ????

      error2.jpg

       

      Jim