topic Re: escape character in qilkview expression in QlikView

escape character in qilkview expression

mbp198 — Fri, 23 Oct 2015 16:22:10 GMT

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 — Fri, 23 Oct 2015 16:29:52 GMT

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 — Fri, 23 Oct 2015 16:40:56 GMT

Thanks sunny it works

sunny_talwar — Fri, 23 Oct 2015 16:42:29 GMT

No problem

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

Best,

Sunny