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

      Hi,

       

      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?