Five Stars

numbers before text

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.

 

1 REPLY
Six Stars

Re: numbers before text

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

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