I feel both of these should work…
I feel both of these should work…
Hi @Tomislav_Mamic,
Backslash (\
) escape char works as expected. i.e. asking the interpreter to trigger a different interpretation of the following char.
Input: Mustn't have
[Title] = "Mustn't have"
→ true[Title] = "Mustn\'t have"
→ falseInput "Sure!", she said
[Title] = "\"Sure\", she said"
→ true[Title] = "Sure, she said"
→ falseWhy you should escape your single quote in your example?
Thanks for reply.
When I filter by this string, it doesn’t match the cell with this text.