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:

      Replace(Replace(Replace([product_category],"[",""),"]",""),",",">")

       

      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!

      Ben