Apostrophe and Quotation Terminator for Expressions

AppSheet AppSheet Q&A
1

Hi!

I am doing expressions that involve words with apostrophe and quotation marks. Suppose having this expression:

LIST(
“ADHESIVE TAPE ELECTRICAL PVC BLACK 0.007"T”,
“PIPE RIGID-STEEL-CONDUIT(RSC) 1"DIA X 10’L”
)

This gives me an error saying that the number of open and closed parenthesis does not match. Is there a way where I can use these inside strings without Appsheet detecting them as parenthesis?

2

@RPD_Mobile_Apps
You can try surrounding with quotes and concatinating like this:

&“)”&

But I actually think you make have to look at all your single and straight quotes and may need to double quote around them…
eg: ‘ “ ‘

Not at a computer right now so can’t check right now. Sorry…

2 Likes
3

You might also check this prior thread:

[Quotation marks in a text string](https://community.appsheet.com/t/quotation-marks-in-a-text-string/282) Questions

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])

1 Like
4

@Mike

Thanks so much! I am using the double quotation now

1 Like
5

Glad to help

6

‘ “ ‘ Esto es lo que estaba buscando hace un tiempo, gracias