Solved: Comparing text with the apostrophe ( ' ) - Page 2

Swoopy · 06-10-2021 08:31 PM

Since this expression is invalid on AppSheet.

[column] = " '"

(Note that any spaces are not allowed in front of the ’ )

I need to prevent user from saving something like,

Height=5 '

( 5’ is preferred)

So I need to include it in Valid If expression.

How to correct it ?

Swoopy

I use LEFT(" “&”’ ", 2) as work around.

My valid expression is

NOT(OR(
   CONTAINS([_THIS], "' "),
   CONTAINS([_THIS], LEFT(" "&"' ", 2))
))

This prevents users from saving texts like
it ’ s
it’ s
it 's
instead of it’s.