https://community.qlik.com/t5/Talend-Studio/tExtractRegexFields-component/m-p/2220344#M14786 try with " ([a-zA-Z]*)[ ]*([a-zA-Z]*)" Thu, 27 Sep 2018 09:09:22 GMT fdenis 2018-09-27T09:09:22Z https://community.qlik.com/t5/Talend-Studio/tExtractRegexFields-component/m-p/2220343#M14785 <P>Hello (I am beginer in talend),</P> <P>I want to create a job using&nbsp;tExtractRegexFields component in order to separate a column into two column.</P> <P>&nbsp;</P> <P>The input column contain firstname last name separated with a space ex: " Steve Jobs". i want an output with two columns firstname "Steve" and another last name "Jobs".</P> <P>&nbsp;</P> <P>I dont find the write expression to put in Regrex: I tried this one&nbsp;"(\\w+)(.*)$" it doesn't work. I tried&nbsp;&nbsp;"<SPAN>&nbsp;</SPAN>([A-Z]*) ([A-Z]*)" it doesn't work too <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P> <P>&nbsp;</P> <P>Could you help me to find the good expression? Thank you</P> Sat, 16 Nov 2024 07:34:40 GMT https://community.qlik.com/t5/Talend-Studio/tExtractRegexFields-component/m-p/2220343#M14785 Anonymous 2024-11-16T07:34:40Z https://community.qlik.com/t5/Talend-Studio/tExtractRegexFields-component/m-p/2220344#M14786 try with " ([a-zA-Z]*)[ ]*([a-zA-Z]*)" Thu, 27 Sep 2018 09:09:22 GMT https://community.qlik.com/t5/Talend-Studio/tExtractRegexFields-component/m-p/2220344#M14786 fdenis 2018-09-27T09:09:22Z