Re: Single quotes in concatenate yield error

Stephen_Ehmann · 03-27-2021 03:37 AM

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:

no single quotes → PASS
SWITCH([_THIS],
“Oustanding”, “”,
“Completed”, “”,
“Waived”, “a” & “b”,
“Not Applicable”, “”,
“Already Have”, “”,
“”
)
single quotes in string but no concatenation → PASS
SWITCH([_THIS],
“Oustanding”, “”,
“Completed”, “”,
“Waived”, “a’'b”,
“Not Applicable”, “”,
“Already Have”, “”,
“”
)
using CONCATENATE instead of & yeilds the same error → FAIL

Steve