topic Re: How to remove the special charters in script level in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-the-special-charters-in-script-level/m-p/1881#M273 <HTML><HEAD></HEAD><BODY><P>check the purgechar function.</P><P></P><P>you can try like this. add all symbols you want to remove.</P><P>You can also add chr(10) for a line break</P><P></P><P><SPAN style="color: #333333; font-family: arial,helvetica,sans-serif;"><SPAN class="statement" style="text-indent: 0px; font-size: 12px; font-style: normal; font-weight: bold;">PurgeChar(</SPAN><SPAN style="text-indent: 0px; font-size: 12px; font-style: normal; font-weight: normal; background-color: #f4f4f4;">Field, '[]""\/'</SPAN><SPAN class="statement" style="text-indent: 0px; font-size: 12px; font-style: normal; font-weight: bold;">)</SPAN></SPAN></P></BODY></HTML> Wed, 17 Jan 2018 08:31:52 GMT zhadrakas 2018-01-17T08:31:52Z How to remove the special charters in script level https://community.qlik.com/t5/QlikView/How-to-remove-the-special-charters-in-script-level/m-p/1880#M272 <HTML><HEAD></HEAD><BODY><P>&nbsp; Hi&nbsp; ..</P><P></P><P>my field like below..</P><P>where ever null data is there "NA" renaming data coming as usual.</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 172px;"><TBODY><TR><TD height="20" width="172"><P>Management </P><P>[]</P></TD></TR><TR><TD height="20">["aaaaa -\u001a Chief Economist for Australia/NZ"]</TD></TR><TR><TD height="20">["bbbbb -\u001a Chief Economist for Australia/NZ"]</TD></TR><TR><TD height="20">["Hilton Worldwide Holdings","Park Hotels \u0026 Resorts Inc - US"]</TD></TR><TR><TD height="20">["Hilton Worldwide Holdings","Park Hotels \u0026 Resorts Inc - US"]</TD></TR></TBODY></TABLE><P>excapted o/p is like below...</P><P><SPAN style="font-size: 13.3333px;">Management </SPAN></P><P><SPAN style="font-size: 13.3333px;">NA</SPAN></P><P><SPAN style="font-size: 13.3333px;">aaaaa&amp; <SPAN style="font-size: 13.3333px;">Chief Economist for AustraliaNZ</SPAN><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">bbbbb &amp;Chief Economist for AustraliaNZ</SPAN></P><P><SPAN style="font-size: 13.3333px;">Hilton Worldwide Holdings</SPAN></P><P><SPAN style="font-size: 13.3333px;">Park Hotels &amp;Resorts Inc - US</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Wed, 17 Jan 2018 07:36:34 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-special-charters-in-script-level/m-p/1880#M272 Anonymous 2018-01-17T07:36:34Z Re: How to remove the special charters in script level https://community.qlik.com/t5/QlikView/How-to-remove-the-special-charters-in-script-level/m-p/1881#M273 <HTML><HEAD></HEAD><BODY><P>check the purgechar function.</P><P></P><P>you can try like this. add all symbols you want to remove.</P><P>You can also add chr(10) for a line break</P><P></P><P><SPAN style="color: #333333; font-family: arial,helvetica,sans-serif;"><SPAN class="statement" style="text-indent: 0px; font-size: 12px; font-style: normal; font-weight: bold;">PurgeChar(</SPAN><SPAN style="text-indent: 0px; font-size: 12px; font-style: normal; font-weight: normal; background-color: #f4f4f4;">Field, '[]""\/'</SPAN><SPAN class="statement" style="text-indent: 0px; font-size: 12px; font-style: normal; font-weight: bold;">)</SPAN></SPAN></P></BODY></HTML> Wed, 17 Jan 2018 08:31:52 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-special-charters-in-script-level/m-p/1881#M273 zhadrakas 2018-01-17T08:31:52Z Re: How to remove the special charters in script level https://community.qlik.com/t5/QlikView/How-to-remove-the-special-charters-in-script-level/m-p/1882#M274 <HTML><HEAD></HEAD><BODY><P>Hi ..</P><P></P><P>Not for remove Replace the Character....</P><P>o/p like above</P></BODY></HTML> Wed, 17 Jan 2018 08:52:21 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-special-charters-in-script-level/m-p/1882#M274 Anonymous 2018-01-17T08:52:21Z