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
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
Thanks sunny it works
I also very recently learned about this. So I am glad I was able to share it with someone else.
Retrieving data ...