Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
SubField(FieldName,'_',2)
May be this?
SubField(FieldName,'_',2)