Single quotes in concatenate yield error

AppSheet AppSheet Q&A
1

There are 2 problems:
A) the fact that this is an error, I don’t think it should be an error
B) the error message is wrong it talks about parens when all the parens are correct

My test case (note the single quotes next to a and b in the string):
SWITCH([_THIS],
“Oustanding”, “”,
“Completed”, “”,
“Waived”, “a’” & “'b”,
“Not Applicable”, “”,
“Already Have”, “”,
“”
)

meets this error:
Expression ‘SWITCH([_THIS], “Oustanding”, “”, “Completed”, “”, “Waived”, “a’” & “'b”, “Not Applicable”, “”, “Already Have”, “”, “” )’ could not be parsed due to exception: Number of opened and closed parentheses does not match.

I tried these variations:

  1. no single quotes → PASS
    SWITCH([_THIS],
    “Oustanding”, “”,
    “Completed”, “”,
    “Waived”, “a” & “b”,
    “Not Applicable”, “”,
    “Already Have”, “”,
    “”
    )

  2. single quotes in string but no concatenation → PASS
    SWITCH([_THIS],
    “Oustanding”, “”,
    “Completed”, “”,
    “Waived”, “a’'b”,
    “Not Applicable”, “”,
    “Already Have”, “”,
    “”
    )

  3. using CONCATENATE instead of & yeilds the same error → FAIL

2

Related:

[How to Extract an Apostrophe ' from text](https://community.appsheet.com/t/how-to-extract-an-apostrophe-from-text/14005) Questions

When trying to remove an apostrophe from this text: [Dimensions] = “100’” using this formula SUBSTITUTE([Dimensions], “'”, “”) I get this error: UNTERMINATED STRING Is there a way for appsheet to not interpret the ’ as a single quote? An escape character or something? Another oddity, If I add a space after the apostrophe, then it clears the error. Very curious behavior??? SUBSTITUTE([Dimensions], "’ ", “”)

[Handling quote and double quotes](https://community.appsheet.com/t/handling-quote-and-double-quotes/37273) Questions

Hi All, I have a text field with the formula: “this is my favorite color: ‘blue’” and I want incorporate a variable on the last word. Note that these single quotes can’t be removed. So I would try this: “this is my favorite color: '”& [Favorite color] &“’” but Appsheet returns an error: could not be parsed due to exception: Unterminated string. Has anyone encounter this problem? I initially posted that question on this post but I’ve met this issue outside of using this quickchart.io. Thanks! …

[How to prefix a single quote in a CONCATENATE?](https://community.appsheet.com/t/how-to-prefix-a-single-quote-in-a-concatenate/32916) Questions

CONCATENATE(“’”, [Some column]) You will get an error saying “Number of opened and closed parentheses does not match.” If you introduce any text around single quote, the error go away. Example, "’ " (space behind the single quote) However, I just need a single quote. Is it a bug? Some background. When you add a phone number with a prefix “+” sign like +1234545 via typing in a column, AppSheet will automatically add a single quote prefix in the google sheet cell. However, if you are setting…

[Apostrophe and Quotation Terminator for Expressions](https://community.appsheet.com/t/apostrophe-and-quotation-terminator-for-expressions/9467) Questions

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?

[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