1 Reply Latest reply: May 15, 2014 10:03 AM by Data Kruncher RSS

    Variable field length to trap

    Mike Mayfield

      I do not use Monarch enough to stay current with some things like how to deal with data of varying length. I have browsed the posts here, but still can seem to figure out what should be a simple matter.

       

      I have an item number that is in an append template because it is not part of detail. The field is something like this, with several spaces before it:

       

      Item: XXXXXXXX / 6840300 "TRAY-PAPER DIAMD #0540 1/4# 1

       

      where the data following "space/space" is not predictable. The data that I want to trap follows "Item: " and varies from 4 to 9 characters, and I can't seem to get rid of the "/" .

       

      I can't seem to find a suitable function that will start with "Item:" and end on "/".

       

      Thanks for your help.

        • Variable field length to trap
          Data Kruncher

          Hi Mike. Welcome to the forum.

           

          If you're including the ITEM: in the field, you can use this:

          [SIZE=2]Trim(LSplit(LSplit(Item,2,"/",1),2,"ITEM:",2))[/SIZE][/code]

           

          If you're not including the ITEM: string, then all that you'll need is:

           

          Trim(LSplit(Item,2,"/",1))[/code]

           

          Try that and let us know your results.

           

          Kruncher