1 Reply Latest reply on Oct 31, 2018 6:59 AM by Ankit Bansal

    the "\" is not picked up in formula's using Tableau Prep

    Robbie Martens



      I'm cleaning an address field in one of my datasets. The AccountAddress comes in like: Street\nCity\nPostcode.


      With the SPLIT (or any other formula) I'm trying to chop this column in multiple columns (Street, City and Postcode). But if I use the formula TRIM like below it doesn't pickup the "\" as a separator:

      SPLIT( [AccountAddress], '\n', 1)


      The \ symbol is also not picked up by formula's like FIND etc.


      Anybody knows a good solution or workaround?