How do I escape characters in strings?

CleanShot 2021-10-07 at 12.01.49
CleanShot 2021-10-07 at 12.02.02

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" → false

Input "Sure!", she said

  • [Title] = "\"Sure\", she said" → true
  • [Title] = "Sure, she said" → false

Why 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.