topic Re: special characters in QlikView https://community.qlik.com/t5/QlikView/special-characters/m-p/484868#M181138 <HTML><HEAD></HEAD><BODY><P>How would the data look like? Some sample please with expected output.</P><P></P><P><STRONG>Update:</STRONG> May be like attached sample.</P></BODY></HTML> Fri, 27 Sep 2013 07:22:21 GMT tresB 2013-09-27T07:22:21Z special characters https://community.qlik.com/t5/QlikView/special-characters/m-p/484866#M181136 <HTML><HEAD></HEAD><BODY><P><BR />Hi all,</P><P></P><P>How can we find the count of the text which has special characters</P><P></P><P>Thanks</P></BODY></HTML> Fri, 27 Sep 2013 07:02:51 GMT https://community.qlik.com/t5/QlikView/special-characters/m-p/484866#M181136 2013-09-27T07:02:51Z Re: special characters https://community.qlik.com/t5/QlikView/special-characters/m-p/484867#M181137 <HTML><HEAD></HEAD><BODY><P>Hi,</P><OL><LI>Use purgechar() to remove Number and text.</LI><LI>Trim() to remove any spaces</LI><LI>Count() the rest to get the count of special character</LI></OL><P>Let me know it this could be helpful.</P><P>-Mohan</P></BODY></HTML> Fri, 27 Sep 2013 07:21:03 GMT https://community.qlik.com/t5/QlikView/special-characters/m-p/484867#M181137 2013-09-27T07:21:03Z Re: special characters https://community.qlik.com/t5/QlikView/special-characters/m-p/484868#M181138 <HTML><HEAD></HEAD><BODY><P>How would the data look like? Some sample please with expected output.</P><P></P><P><STRONG>Update:</STRONG> May be like attached sample.</P></BODY></HTML> Fri, 27 Sep 2013 07:22:21 GMT https://community.qlik.com/t5/QlikView/special-characters/m-p/484868#M181138 tresB 2013-09-27T07:22:21Z