topic String help in QlikView https://community.qlik.com/t5/QlikView/String-help/m-p/1136784#M907500 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have scenario pls help</P><P></P><P>how to remove special characters in below string.</P><P></P><P>1234@5678#9$10</P><P></P><P>I tried with subfield function.but didn't work&nbsp; </P><P></P><P>Any suggestions?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z String help https://community.qlik.com/t5/QlikView/String-help/m-p/1136784#M907500 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have scenario pls help</P><P></P><P>how to remove special characters in below string.</P><P></P><P>1234@5678#9$10</P><P></P><P>I tried with subfield function.but didn't work&nbsp; </P><P></P><P>Any suggestions?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/String-help/m-p/1136784#M907500 2020-11-25T16:16:04Z Re: String help https://community.qlik.com/t5/QlikView/String-help/m-p/1136785#M907501 <HTML><HEAD></HEAD><BODY><P>KeepChar(YourString,'0123456789') as YourString</P><P>or</P><P>=KeepChar('1234@5678#9$10','0123456789')</P></BODY></HTML> Fri, 17 Jun 2016 09:05:42 GMT https://community.qlik.com/t5/QlikView/String-help/m-p/1136785#M907501 MK_QSL 2016-06-17T09:05:42Z Re: String help https://community.qlik.com/t5/QlikView/String-help/m-p/1136786#M907502 <HTML><HEAD></HEAD><BODY><P>or</P><P></P><P>Purgechar(Field,'!~@#$%^&amp;*') as NewField</P><P></P><P>Note: Include all special characters which you want to remove</P></BODY></HTML> Fri, 17 Jun 2016 09:13:25 GMT https://community.qlik.com/t5/QlikView/String-help/m-p/1136786#M907502 Kushal_Chawda 2016-06-17T09:13:25Z