Concatenate with ' in string

AppSheet AppSheet Q&A
,
1

I’m trying to concatenate a few fields and some text.

[Width for Description]&“mm '”&[Range]&"’ "&[Finish Name]

But this has an error

Expression ‘[Width for Description]&“mm '”&[Range]&"’ "&[Finish Name]’ was unable to be parsed: Unterminated string.

When I change it to [Width for Description]&"mm ’ “&[Range]&”’ "&[Finish Name] with a space after the ’ it is ok.

I tried CONCATENATE([Width… but that gave the same error.

Is there any way I can have ’ with no space and then [Range] after it?

I tried putting it inside TEXT(“mm '”), but that doesn’t work either. It says number of parentheses don’t match, but if I put the space back in it’s ok.

2

Can you try:

CONCATENATE([Width for Description],"mm ",LEFT("’ “, 1),[Range],LEFT("’ “, 1), " ",[Finish Name])

Based on this:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/How-to-Extract-an-Apostrophe-from-text/m-p/268184#M47646

3 Likes
3

Thanks. That worked.

Should have searched harder.

I think I forgot what an apostrophe was called :slightly_smiling_face:

2 Likes
4

Well actually, I’m French : quotation marks are named “apostrophe” here… it was easier for me to look for it hahaha

3 Likes