Suppose I have Beast Mode the following syntax:
WHEN `lastName` = 'O'Sullivan'
The apostrophe in O'Sullivan breaks the Beast Mode. Is there a way to escape the character?
I tried a couple mySQL syntax with no luck. The only thing that I found was to do a LIKE operator.
CASE WHEN LASTNAME LIKE 'O%' AND LASTNAME LIKE '%Sullivan' THEN ...
The statement above just states that the last name must start with O and end with Sullivan.
Hope this helps
@brianfriedman I have submitted an bug ticket with development for this and requested a way to escape charicters in Beast Modes. I will update you on it's progress when I know more.
Ticket # 00474129
I hit this same issue.
Until the fixed gets pushed out, a possible work-around is
CASE WHEN LASTNAME LIKE 'O_Sullivan' THEN ...
The "_" is a wildcard for a single character only. This will fail if a character other than an apostrophe could be between the "O" and "S", but will probably work for most specifica cases.
To escape a single-quote in a Beast Mode equals "=" operation, use 2 single quotes instead of 1. For example:
CASE WHEN `lastName` = 'O''Sullivan' THEN ...
Hello user08600, please see my previous response. Two apostrophes in a row represents an escaped apostrophe. For example, 'O''Sullivan' is valid for specifying the name O'Sullivan with an escape on the apostrophe.