https://community.qlik.com/t5/Talend-Studio/replaceAll-Not-working-for-numbers/m-p/2196626#M696 <P>I am trying to remove numbers from the myNumbers column which is a String but I am getting the error "<FONT color="#FF0000">java.lang.NullPointerException</FONT>".</P> <P>&nbsp;</P> <P>My tMap looks like this:</P> <P><STRONG>row3.myNumbers.replaceAll("[0-9]","").trim();</STRONG></P> <P>&nbsp;</P> <P>My sample file:</P> <P>myLetters,myNumbers<BR />abc,A123<BR />def,B456<BR />hij,C789<BR />klm,D010</P> <P>&nbsp;</P> <P><STRONG>Any ideas?&nbsp;</STRONG></P> Fri, 10 Apr 2020 04:24:04 GMT talendtester 2020-04-10T04:24:04Z https://community.qlik.com/t5/Talend-Studio/replaceAll-Not-working-for-numbers/m-p/2196626#M696 <P>I am trying to remove numbers from the myNumbers column which is a String but I am getting the error "<FONT color="#FF0000">java.lang.NullPointerException</FONT>".</P> <P>&nbsp;</P> <P>My tMap looks like this:</P> <P><STRONG>row3.myNumbers.replaceAll("[0-9]","").trim();</STRONG></P> <P>&nbsp;</P> <P>My sample file:</P> <P>myLetters,myNumbers<BR />abc,A123<BR />def,B456<BR />hij,C789<BR />klm,D010</P> <P>&nbsp;</P> <P><STRONG>Any ideas?&nbsp;</STRONG></P> Fri, 10 Apr 2020 04:24:04 GMT https://community.qlik.com/t5/Talend-Studio/replaceAll-Not-working-for-numbers/m-p/2196626#M696 talendtester 2020-04-10T04:24:04Z https://community.qlik.com/t5/Talend-Studio/replaceAll-Not-working-for-numbers/m-p/2196627#M697 Need to check if there exist null value in this column, you can change the expression to: <BR />row3.myNumbers==null?null:row3.myNumbers .replaceAll("[0-9]","").trim() <BR /> <BR />Regards <BR />Shong Fri, 10 Apr 2020 04:37:54 GMT https://community.qlik.com/t5/Talend-Studio/replaceAll-Not-working-for-numbers/m-p/2196627#M697 Anonymous 2020-04-10T04:37:54Z