Formula where value contains a single quote
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)
0
Answers
-
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)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Awesome, thank you!
0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 137 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 53 Domo Everywhere
- 2K Charting
- 997 Ideas Exchange
- 900 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 19 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 572 日本支部