topic Re: colon in data issue in QlikView https://community.qlik.com/t5/QlikView/colon-in-data-issue/m-p/1202244#M874431 <HTML><HEAD></HEAD><BODY><P>try this in script:</P><P></P><P>If(Region ='Int'&amp;Chr(39)&amp;'l Americas','Americas') as Region</P><P></P><P>hope this helps</P></BODY></HTML> Mon, 31 Oct 2016 21:08:50 GMT Frank_Hartmann 2016-10-31T21:08:50Z colon in data issue https://community.qlik.com/t5/QlikView/colon-in-data-issue/m-p/1202243#M874430 <HTML><HEAD></HEAD><BODY><P>I have data like </P><P></P><P>Region</P><P>Int'l Americas</P><P></P><P>But I have to rename this to Americas so I am using below expression but that give me error...</P><P></P><P>If(Region =' <SPAN style="font-size: 13.3333px;">Int'l Americas','Americas') as Region</SPAN></P><P></P><P>Qlikview doesnt like this .how do I resolve this sissue ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/colon-in-data-issue/m-p/1202243#M874430 apthansh 2020-11-25T16:16:04Z Re: colon in data issue https://community.qlik.com/t5/QlikView/colon-in-data-issue/m-p/1202244#M874431 <HTML><HEAD></HEAD><BODY><P>try this in script:</P><P></P><P>If(Region ='Int'&amp;Chr(39)&amp;'l Americas','Americas') as Region</P><P></P><P>hope this helps</P></BODY></HTML> Mon, 31 Oct 2016 21:08:50 GMT https://community.qlik.com/t5/QlikView/colon-in-data-issue/m-p/1202244#M874431 Frank_Hartmann 2016-10-31T21:08:50Z Re: colon in data issue https://community.qlik.com/t5/QlikView/colon-in-data-issue/m-p/1202245#M874432 <HTML><HEAD></HEAD><BODY><P>You can escape the ' in your string by putting another ' before it:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If(Region = '</SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Int''l Americas','Americas') as Region</SPAN></P></BODY></HTML> Mon, 31 Oct 2016 21:15:33 GMT https://community.qlik.com/t5/QlikView/colon-in-data-issue/m-p/1202245#M874432 Nicole-Smith 2016-10-31T21:15:33Z Re: colon in data issue https://community.qlik.com/t5/QlikView/colon-in-data-issue/m-p/1202246#M874433 <HTML><HEAD></HEAD><BODY><P>Thank you:)</P></BODY></HTML> Tue, 01 Nov 2016 02:12:27 GMT https://community.qlik.com/t5/QlikView/colon-in-data-issue/m-p/1202246#M874433 apthansh 2016-11-01T02:12:27Z