10 Replies Latest reply on Apr 26, 2018 10:10 AM by Deepak Rai

    Trim String Calculation

    ChicagoTableauUser

      I saw a post similar to what im trying to do but the wrong way around, please advise how I can do the below:

       

      Dimension value is in a string like below:

      "Bart Simpson - XXXXXX"

      "Maggie Simpson - XXX"

       

      I want a formula that will take the values from the right up to the space e.g XXXXXX and XXX

       

      Thanks in advance!