Apostropohe in text

[#1]

I am trying to use a show conditional expression to show a text box when a particular channel is selected, however, the value defined in the dimension has an apostrophe in the text string.

If(Channel = 'Angie's List', True(), False()).

This causes an error in the expression due to the apostrophe in the name of the channel. 

Thoughts?

[sunny_talwar · Accepted solution]

Try this:

If(Channel = 'Angie''s List', True(), False()).

Note, I used two single quotes and not a double quote above

Escape sequences

[#3]

Thanks Sunny!

That was quick too!  I tried all sorts of combinations, but didnt think to try two single quotes.

[sunny_talwar]

Ya unless you know about it, it is difficult to think that something like that would exist. Def. go through HIC's blog and you will learn many other interesting things about the escape sequence.