indexing

[mario-sarkis]

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

[bramkn · Accepted solution]

subfield(Input,'|',1)

[stabben23]

use subfield, =subfield(Input,'|')