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')

    CHINKS Apprentice

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

       

       

      Input String = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"

       

      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 ?

       

       

      Thanks.