4 Replies Latest reply on Sep 26, 2018 12:02 AM by andre.kempe.1

    Tableau Prep: CSV file, import, delete text parts of a field

    andre.kempe.1

      Hello, I am experimenting with Prep but have difficulties with one single CSV file import.

      In the csv

      some lines look like this: .... purchase,{af_revenue:19.99,af_content_type:subscriptions,,,,},19.99,USD,19.99, ....

      some other lines look like this: ... purchase,{},19.99,USD,19.99, ....

       

      So basically Tableau understands the comma inside the {} as field separators and the table is becoming a total mess.

      How can I handle this best? Ideal solution would be a function that allows me to erase everything inside the {} so all lines look similar. Does this need to happen in the CSV file before I import into Prep or can Prep help me doing that?