1 Reply Latest reply: Nov 26, 2017 3:50 AM by Anil Babu RSS

    SubField Extract

    Omer Zeira

      Hi,

       

       

      Lets say that I have a list in one of my tables that contain data that look like this:

       

      2018_BID_HC Cycle

      2018_Stacker_HC Cycle

       

      Now, During the LOAD I want to extract the words between the '_' (BID, Stacker)

      I try the SubField Function but it extract only the first '_' (result: 'BID_HC Cycle', 'Stacker_HC Cycle')

       

      Any suggestions?

       

      Thx!

      Omer