https://community.qlik.com/t5/QlikView/Write-a-string-like-Cote-d-Ivoire-into-text-object-or-expression/m-p/1686170#M726142 <P>Hi all,</P><P>I basicly need to write a word like 'Cote d'Ivoire' without any errors into text object or expression.</P><P>The symbol ' in the word is mandatory. Does it exist a symbol that replace the following one: ' ?</P> Wed, 25 Nov 2020 16:16:04 GMT fabb95501 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Write-a-string-like-Cote-d-Ivoire-into-text-object-or-expression/m-p/1686170#M726142 <P>Hi all,</P><P>I basicly need to write a word like 'Cote d'Ivoire' without any errors into text object or expression.</P><P>The symbol ' in the word is mandatory. Does it exist a symbol that replace the following one: ' ?</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Write-a-string-like-Cote-d-Ivoire-into-text-object-or-expression/m-p/1686170#M726142 fabb95501 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Write-a-string-like-Cote-d-Ivoire-into-text-object-or-expression/m-p/1686182#M726143 <P>Hi,</P><P>the char number of ' is 39 so you can use it in the Replace() function &gt; chr(39).</P><P>But the easiest way is to use the escape sign - you basically write it twice. This works with other reserved characters.</P><P>So&nbsp;<EM>'Cote d<STRONG>''</STRONG>Ivoire'</EM></P> Thu, 19 Mar 2020 15:40:56 GMT https://community.qlik.com/t5/QlikView/Write-a-string-like-Cote-d-Ivoire-into-text-object-or-expression/m-p/1686182#M726143 RadovanOresky 2020-03-19T15:40:56Z