3 Replies Latest reply on Dec 13, 2017 12:17 AM by Julian Wigman

    How to use substring to extract the first character up to the Last Index of('Matching Text')


      I would like to capture the beginning of the input string upto the Matching string XYZ as my result...





      Input String.LastIndexOf('XYZ') returns the value of 24

      Input String.Length = 26


      What would I use to send characters 1-26 from my Input String to my Result?

      some kind of Substring or MidString or LeftString ?