Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
fabb95501
Partner - Contributor III
Partner - Contributor III

Write a string like 'Cote d'Ivoire' into text object or expression

Hi all,

I basicly need to write a word like 'Cote d'Ivoire' without any errors into text object or expression.

The symbol ' in the word is mandatory. Does it exist a symbol that replace the following one: ' ?

1 Solution

Accepted Solutions
RadovanOresky
Partner Ambassador
Partner Ambassador

Hi,

the char number of ' is 39 so you can use it in the Replace() function > chr(39).

But the easiest way is to use the escape sign - you basically write it twice. This works with other reserved characters.

So 'Cote d''Ivoire'

View solution in original post

1 Reply
RadovanOresky
Partner Ambassador
Partner Ambassador

Hi,

the char number of ' is 39 so you can use it in the Replace() function > chr(39).

But the easiest way is to use the escape sign - you basically write it twice. This works with other reserved characters.

So 'Cote d''Ivoire'