Apostrophe and Quotation Terminator for Expressions

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?

@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…

1 Like

You might also check this prior thread:

1 Like

@Mike

Thanks so much! I am using the double quotation now

1 Like

Glad to help