I am trying to remove an apostrophe from a whereClause in Codeless, but for some reason it is not working.
Here is what I am doing:
I am receiving code 1017
Where clause 'tutor_name = 'Brandy O'Donnell'' is invalid.
Indeed, the tutor_name is Brandy O’Donnell. I have checked that the replacement block is a double apostrope (’’) and not a quotation mark ("). With other tutor names that contain apostrophes, I do not have this issue, the RegExp block works fine.
In the console, the double apostrophe works: