escape character in qilkview expression

[mbp198]

I have expression that is like

=Replace([FIN-AP-Company Code Country Text],'Cote d'Ivoire','Ivory Coast')

since Cote d'Ivoire is having ' it is giving error in the expression, I wonder if there is any excape character in qlikview

[sunny_talwar]

Try this may be:

=Replace([FIN-AP-Company Code Country Text],'Cote d''Ivoire','Ivory Coast')

Notice the two single quotes. Look for escape sequence here : Escape sequences

[mbp198]

Thanks sunny it works

[sunny_talwar]

No problem

I also very recently learned about this. So I am glad I was able to share it with someone else.

Best,

Sunny