Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear,
hope that you can help with this,
I have a field looks like this :
Input:
1|225536
11|31256323
13|54335
2|55363
I need the output field in the script all numbers before " | " in this case the output will be
1
11
13
2
Thank you
subfield(Input,'|',1)
subfield(Input,'|',1)
use subfield, =subfield(Input,'|')