5 Replies Latest reply on Apr 19, 2018 3:39 AM by Ben Powis

    Replacing the " character in a string

    Ben Powis

      Hi Tableau gang!


      I have some data with entries that looks like this:


      "Category 1", "Category 2"


      I would like them to look like this:


      Category 1 > Category 2


      I've used `REPLACE` to get me as far as removing everything except the " around the text:



      How can I replace these? When I add them in the format above I get the 'Unterminated string' error. DO I need to escape them somehow?


      Thanks for your help!