colon in data issue

[apthansh]

I have data like

Region

Int'l Americas

But I have to rename this to Americas so I am using below expression but that give me error...

If(Region =' Int'l Americas','Americas') as Region

Qlikview doesnt like this .how do I resolve this sissue ?

[Frank_Hartmann]

try this in script:

If(Region ='Int'&Chr(39)&'l Americas','Americas') as Region

hope this helps

[Nicole-Smith · Accepted solution]

You can escape the ' in your string by putting another ' before it:

If(Region = 'Int''l Americas','Americas') as Region

[apthansh]

Thank you:)