topic Re: Remove unwanted characters in QlikView https://community.qlik.com/t5/QlikView/Remove-unwanted-characters/m-p/10273#M511478 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>PurgeChar(Conv_Client, Chr(34)) as <STRONG>Conv_Client</STRONG></STRONG></P></BODY></HTML> Tue, 24 Apr 2018 13:13:02 GMT sunny_talwar 2018-04-24T13:13:02Z Remove unwanted characters https://community.qlik.com/t5/QlikView/Remove-unwanted-characters/m-p/10272#M511477 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I'm loading an object from a database with names that start and ends with <STRONG style="font-size: 12pt;">"</STRONG></P><P><SPAN style="font-size: 10pt;">What is the best way to remove <STRONG style="font-size: 12pt;">".</STRONG><SPAN style="font-size: 10pt;"> E.g "altea" -&gt; altea</SPAN></SPAN></P><P><SPAN style="font-size: 10pt;">In the extract script or in the application?</SPAN></P><P><IMG alt="rename.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200652_rename.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 24 Apr 2018 13:10:03 GMT https://community.qlik.com/t5/QlikView/Remove-unwanted-characters/m-p/10272#M511477 stekol61 2018-04-24T13:10:03Z Re: Remove unwanted characters https://community.qlik.com/t5/QlikView/Remove-unwanted-characters/m-p/10273#M511478 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>PurgeChar(Conv_Client, Chr(34)) as <STRONG>Conv_Client</STRONG></STRONG></P></BODY></HTML> Tue, 24 Apr 2018 13:13:02 GMT https://community.qlik.com/t5/QlikView/Remove-unwanted-characters/m-p/10273#M511478 sunny_talwar 2018-04-24T13:13:02Z Re: Remove unwanted characters https://community.qlik.com/t5/QlikView/Remove-unwanted-characters/m-p/10274#M511479 <HTML><HEAD></HEAD><BODY><P>Or use Replace</P><P></P><P><STRONG>Replace(Conv_Client, Chr(34), '') as Conv_Client</STRONG></P></BODY></HTML> Tue, 24 Apr 2018 13:13:40 GMT https://community.qlik.com/t5/QlikView/Remove-unwanted-characters/m-p/10274#M511479 sunny_talwar 2018-04-24T13:13:40Z