topic numbers before text in Talend Studio

topic numbers before text in Talend Studio https://community.qlik.com/t5/Talend-Studio/numbers-before-text/m-p/2325889#M95437 <P>Hello,</P> <P> </P> <P>Please could you help me with below request.</P> <P> </P> <P><U>input</U></P> <P> </P> <P>abcdef 12 abcdef</P> <P>abcdef 2 abcdef</P> <P> </P> <P><U>output</U></P> <P>12</P> <P>2</P> <P> </P> <P>how do i select just numbers before the before string abcdef</P> <P> </P> <P>Thanks.</P> <P> </P> Fri, 10 Nov 2017 22:41:57 GMT Anonymous 2017-11-10T22:41:57Z numbers before text https://community.qlik.com/t5/Talend-Studio/numbers-before-text/m-p/2325889#M95437 <P>Hello,</P> <P> </P> <P>Please could you help me with below request.</P> <P> </P> <P><U>input</U></P> <P> </P> <P>abcdef 12 abcdef</P> <P>abcdef 2 abcdef</P> <P> </P> <P><U>output</U></P> <P>12</P> <P>2</P> <P> </P> <P>how do i select just numbers before the before string abcdef</P> <P> </P> <P>Thanks.</P> <P> </P> Fri, 10 Nov 2017 22:41:57 GMT https://community.qlik.com/t5/Talend-Studio/numbers-before-text/m-p/2325889#M95437 Anonymous 2017-11-10T22:41:57Z Re: numbers before text https://community.qlik.com/t5/Talend-Studio/numbers-before-text/m-p/2325890#M95438 Use textractregexfields<BR /><A href="https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/gDLE3n7ZkrbHVl8Joqu1HA" target="_blank" rel="nofollow noopener noreferrer">https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/gDLE3n7ZkrbHVl8Joqu1HA</A><BR /><BR />With regex<BR />"([a-z]*) ([0-9]*) ([a-z]*)" Sat, 11 Nov 2017 07:54:00 GMT https://community.qlik.com/t5/Talend-Studio/numbers-before-text/m-p/2325890#M95438 Anonymous 2017-11-11T07:54:00Z