https://community.qlik.com/t5/App-Development/How-to-isolate-text-before-numbers-in-string/m-p/2054967#M86668 <P>Can you add a sample dataset ?</P> Thu, 30 Mar 2023 06:24:22 GMT sk002 2023-03-30T06:24:22Z https://community.qlik.com/t5/App-Development/How-to-isolate-text-before-numbers-in-string/m-p/2054954#M86663 <P>Hi all</P> <P>I want to isolate the name in the string before the 'point': FIRSTNAME.LASTNAME1.5431581498658286E12</P> <P>I am using this:&nbsp;</P> <P>Left(accountmanager, If(FindOneOf(accountmanager, '0123456789') &gt; 0, FindOneOf(accountmanager, '0123456789'), Len(accountmanager)))</P> <P>But then I get:</P> <P>FIRSTNAME.LASTNAME1 (I want to eliminate the '1') and just recover the name.&nbsp;</P> <P>&nbsp;</P> <P>Thx!</P> <P>Femke</P> Thu, 30 Mar 2023 05:47:46 GMT https://community.qlik.com/t5/App-Development/How-to-isolate-text-before-numbers-in-string/m-p/2054954#M86663 Femke_DPG 2023-03-30T05:47:46Z https://community.qlik.com/t5/App-Development/How-to-isolate-text-before-numbers-in-string/m-p/2054966#M86667 <P>Hi Review the Subfield function.</P> <P>Try Somthing like</P> <P>SUBFIELD(<SPAN>accountmanager,'.',1</SPAN>) as FirstName</P> <P>SUBFIELD(<SPAN>accountmanager,'.',2</SPAN>) as SurnameName</P> <P>IF you want to remove a number of the end</P> <P>LEFT(SUBFIELD(<SPAN>accountmanager,'.',2</SPAN>),LEN(SUBFIELD(<SPAN>accountmanager,'.',2</SPAN>))-1) as SurnameName</P> Thu, 30 Mar 2023 06:24:03 GMT https://community.qlik.com/t5/App-Development/How-to-isolate-text-before-numbers-in-string/m-p/2054966#M86667 Mark_Little 2023-03-30T06:24:03Z https://community.qlik.com/t5/App-Development/How-to-isolate-text-before-numbers-in-string/m-p/2054967#M86668 <P>Can you add a sample dataset ?</P> Thu, 30 Mar 2023 06:24:22 GMT https://community.qlik.com/t5/App-Development/How-to-isolate-text-before-numbers-in-string/m-p/2054967#M86668 sk002 2023-03-30T06:24:22Z