numbers before text

[Anonymous]

Hello,

Please could you help me with below request.

input

abcdef 12 abcdef

abcdef 2 abcdef

output

12

2

how do i select just numbers before the before string abcdef

Thanks.

[Anonymous]

Use textractregexfields
https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/gDLE3n7ZkrbHVl8Joqu1HA

With regex
"([a-z]*) ([0-9]*) ([a-z]*)"