4 Replies Latest reply: May 15, 2014 9:58 AM by PeterAMurphy _ RSS

    LSPLIT

    PeterAMurphy _

      Does anybody know how to format the LSPLIT function to break up a field into subsets using 2 characters?

       

      For example:

       

      Tammy L Reddish L:Gmac Mtg Corp

       

      I want to break this field into two subsets using "L:" as the marker.

       

      I can only seem to get it to recognize the first character "L"

       

      I am using the following LSPLIT command:

       

      LSPLIT(owner_bank,2,"L:",1)

       

      Thank you!!