3 Replies Latest reply on Aug 3, 2016 12:12 PM by Tom W

    Pulling Text from String

    Ron Bayes

      Hello -

       

      Anyone know the best way to pull a piece of text from a string that sits between two characters?  For example, if the full string is ABC~DEF~GHI~alpha~12345 I want the calculation to produce 'alpha' as the end result.  I'm guessing it involves Find nth but my attempts have not been successful.

       

      Thanks!!