3 Replies Latest reply on Jan 10, 2014 9:27 AM by Alex Kerin

    Issue with data in double quotes.

    Rohith Reddy

      We have a tab separated file(with extension .txt or .csv) where in the data is in below pattern,

       

      Col1       Col2                                       Col3

      1              {“description1”}               a

      2              {“description2”}               b

      3              {“description3”}               c

      4              {“description4”}               d

       

      When I open this file through tableau with separator as tab, then tableau shows me only two columns and the data is loaded as below,

      Col1     Col2

      1         1          {

      2         2          {

      3         3          {

      4         4          {

       

      As it is excluding all the data from the particular row after {.

       

      Can you please let me know how to handle this kind of data in tableau.