topic Re: Phone Number Cleanup - Replace non-numeric in QlikView https://community.qlik.com/t5/QlikView/Phone-Number-Cleanup-Replace-non-numeric/m-p/708162#M1077813 <HTML><HEAD></HEAD><BODY><P>Awesome! Thank you</P><P></P><P>Not sure how i missed that looking through the QV guide</P></BODY></HTML> Fri, 18 Jul 2014 17:39:44 GMT 2014-07-18T17:39:44Z Phone Number Cleanup - Replace non-numeric https://community.qlik.com/t5/QlikView/Phone-Number-Cleanup-Replace-non-numeric/m-p/708160#M1077810 <HTML><HEAD></HEAD><BODY><P>Howdy!</P><P></P><P>I would like to be able to remove all non numeric characters from a phone number field.</P><P></P><P>Examples of values in my&nbsp; Phone1 field</P><P>1) (999)999-9999</P><P>2 9999999999</P><P>3) 999-999-9999</P><P></P><P>Essentially, no matter what, i want to find and replace all (,),- with ''</P><P></P><P>Much thanks,</P><P>-DC</P></BODY></HTML> Fri, 18 Jul 2014 17:35:01 GMT https://community.qlik.com/t5/QlikView/Phone-Number-Cleanup-Replace-non-numeric/m-p/708160#M1077810 2014-07-18T17:35:01Z Re: Phone Number Cleanup - Replace non-numeric https://community.qlik.com/t5/QlikView/Phone-Number-Cleanup-Replace-non-numeric/m-p/708161#M1077812 <HTML><HEAD></HEAD><BODY><P>try:</P><P></P><P>purgechar(Phone1, ')(-')</P><P></P><P>Hope this helps!</P></BODY></HTML> Fri, 18 Jul 2014 17:37:09 GMT https://community.qlik.com/t5/QlikView/Phone-Number-Cleanup-Replace-non-numeric/m-p/708161#M1077812 jerem1234 2014-07-18T17:37:09Z Re: Phone Number Cleanup - Replace non-numeric https://community.qlik.com/t5/QlikView/Phone-Number-Cleanup-Replace-non-numeric/m-p/708162#M1077813 <HTML><HEAD></HEAD><BODY><P>Awesome! Thank you</P><P></P><P>Not sure how i missed that looking through the QV guide</P></BODY></HTML> Fri, 18 Jul 2014 17:39:44 GMT https://community.qlik.com/t5/QlikView/Phone-Number-Cleanup-Replace-non-numeric/m-p/708162#M1077813 2014-07-18T17:39:44Z