2 Replies Latest reply: May 12, 2012 7:23 AM by Ionut Biliuti RSS

    load csv file whith / " characters

    Ionut Biliuti

      Hi,

      When I load from a csv file with a field containing this characters / " all the records are skipped until occurs a new appearance of /"

      This is the contents of the csv file:

       

      1,Item xx,33

      2,Item AA,22

      3,Item yy,5

      4,Item  1 / " ,3

      5,Item xx,7

      6,Item ACB,1

      7,Item xx,8

      8,Item  7 / ",3

      9,Item CC,4

      10,Item xx,78

      11,Item AA,5

      12,Item xx,3

      13,Item AA,2

      14,Item yy,77

       

      and this is the result of load

      untitled.JPG

      If I export the Table box to csv I get this:

       

      1,Item xx,33

      2,Item AA,22

      3,Item yy,5

      4,"Item  1 / ""","3

      5"

      9,Item CC,4

      10,Item xx,78

      11,Item AA,5

      12,Item xx,3

      13,Item AA,2

      14,Item yy,77

       

      There is a way to solve this without replace characters / " in field ?

      Thanks for help,

      Ionut