Count_if doest not work properly if there is a quote in string
I am trying to count certain strings in a column but the formula breaks if the string has quotes. here is the code I used.
- count_if("column"."table" like '%I don't live here%')
the single quote in the string is breaking the code and the formula doesn't work. Is there a way to overcome this?