topic Re: Replace with ' in QlikView https://community.qlik.com/t5/QlikView/Replace-with/m-p/395268#M147421 <HTML><HEAD></HEAD><BODY><P>Wonderful. Thanks for the quick response, Its working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 28 Feb 2013 19:09:11 GMT 2013-02-28T19:09:11Z Replace with ' https://community.qlik.com/t5/QlikView/Replace-with/m-p/395266#M147419 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp; I need to replace a character with '. Please help me on this. Below is the example</P><P></P><P>&nbsp;&nbsp; replace(children**s,'**',''')</P><P>&nbsp;&nbsp; output should be children's</P><P></P><P>&nbsp; Anybody??</P><P></P><P>Thanks,</P><P>Ravi.</P></BODY></HTML> Thu, 28 Feb 2013 19:03:08 GMT https://community.qlik.com/t5/QlikView/Replace-with/m-p/395266#M147419 2013-02-28T19:03:08Z Re: Replace with ' https://community.qlik.com/t5/QlikView/Replace-with/m-p/395267#M147420 <HTML><HEAD></HEAD><BODY><P>Try: replace('children**s','**',chr(39))</P></BODY></HTML> Thu, 28 Feb 2013 19:04:43 GMT https://community.qlik.com/t5/QlikView/Replace-with/m-p/395267#M147420 Gysbert_Wassenaar 2013-02-28T19:04:43Z Re: Replace with ' https://community.qlik.com/t5/QlikView/Replace-with/m-p/395268#M147421 <HTML><HEAD></HEAD><BODY><P>Wonderful. Thanks for the quick response, Its working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 28 Feb 2013 19:09:11 GMT https://community.qlik.com/t5/QlikView/Replace-with/m-p/395268#M147421 2013-02-28T19:09:11Z