https://community.qlik.com/t5/Talend-Studio/String-Handling-in-tMap/m-p/2336095#M104583 <P>If its the only numeric in the string :</P><P>Set this in the tmap output row : </P><P>row5.Example.replaceAll("\\D","")</P><P>it will suppress all non digit char from the string</P><P>Send me Love and Kudos</P> Tue, 06 Apr 2021 16:16:35 GMT gjeremy1617088143 2021-04-06T16:16:35Z https://community.qlik.com/t5/Talend-Studio/String-Handling-in-tMap/m-p/2336094#M104582 <P>Hi, </P><P></P><P></P><P>I have a column <B>row5.Example</B> and the values will be like </P><P><B>CN=HYAHCU YXCUKSRM,OU=20992021,OU=Employees,O=CM,DC=avrhcjk,DC=otn,DC=com. </B>How will I get only numeric value that is <B>20992021 </B></P><P>as result/output by using tMap or any other way.</P><P></P><P></P><P>Note : In this scenario we hare 20k records and all the records are similar.</P> Sat, 16 Nov 2024 00:18:28 GMT https://community.qlik.com/t5/Talend-Studio/String-Handling-in-tMap/m-p/2336094#M104582 vamsi99 2024-11-16T00:18:28Z https://community.qlik.com/t5/Talend-Studio/String-Handling-in-tMap/m-p/2336095#M104583 <P>If its the only numeric in the string :</P><P>Set this in the tmap output row : </P><P>row5.Example.replaceAll("\\D","")</P><P>it will suppress all non digit char from the string</P><P>Send me Love and Kudos</P> Tue, 06 Apr 2021 16:16:35 GMT https://community.qlik.com/t5/Talend-Studio/String-Handling-in-tMap/m-p/2336095#M104583 gjeremy1617088143 2021-04-06T16:16:35Z