Quotation marks in a text string

(Marc Dillon) #1

In other languages, you can include quotation marks in a text string by surrounding the string with the opposite marking, i.e. single quotes around double quotes, or double quotes around single quotes. Appsheet does not seem to like this. I’m trying to use 6", as in “six inch”, in an expression. I’ve tried ‘6"’, text(6"), text(‘6"’), to no avail. Is Appsheet capable of handling this, and if so, how?

Specifically I’m trying to see if 6" is in a list of text items: IN( text(6") , [column])

Apostrophe and Quotation Terminator for Expressions
(Tony Fader) #2

AppSheet’s formulas try to follow the conventions set by Excel formulas. In this case, you can escape a double quote by doing a double double quote. Confused? Here’s an example:

IN("6""", [Column])

(Marc Dillon) #3

Gotcha, thanks. Didn’t know that about Excel