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

    SubField Extract

    Omer Zeira




      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?