select numbers before selected 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 · Accepted solution]

Please refer below thread
https://community.talend.com/t5/Design-and-Development/numbers-before-text/m-p/42319#M12459