Handling quote and double quotes

[teambelair]

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!

[Marc_Dillon · Accepted solution]

This thread will probably help:

How to prefix a single quote in a CONCATENATE? 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…

Try this as your end expression, based on the info in the above thread. Copy and paste it exactly.

“this is my favorite color: ‘"”& [Favorite color] &"’""