Formula where value contains a single quote

BrittanyD

I'm looking to write a formula where the value I'm searching for contains a single quote. Because Domo views single quotes as the start and end of my value, I receive a syntax error. Any known workarounds so that I can include a single quote without throwing off the formula?

This is the formula I'm going for:

(CASE when `commitment_comb` like '%Q1 '22%' then 'Q1 2022' else 'other' end)

GrantSmith

If you double up the single quotes it'll escape it to a single quote in your string:

(CASE when `commitment_comb` like '%Q1 ''22%' then 'Q1 2022' else 'other' end)

BrittanyD

Awesome, thank you!