How to SUBSTUTITE a '?

[PocketSurvey]

SUBSTITUTE( “’”, “_”) gives syntax error.

How do you substitute a quote character (’)

The reason I need to do this is to get the correct file name because Appsheet seems to automatically substitute ’ with - for some reason when creating a PDF giving rise to a mismatch in the physical file and the original filename

[Aurelien]

PocketSurvey:

SUBSTITUTE( “’”, “_”)

Hi, did you try that ?

SUBSTITUTE( “\’”, “_”)

Just an idea…

[PocketSurvey]

Does not work

[Steve]

Search and replace double quotes Questions

Try: SUBSTITUTE([NAME], '"', "!")

[Austin]

help.appsheet.com

SUBSTITUTE()

Text with replacements

Need the column you want to SUBSTITUTE the value in.

[PocketSurvey]

I am doing SUBSTITUTE([WhaterField] , “’”, _")

Its that fact that " " with ’ inside foes not work!

Other sunstutute are OK.

Most languages can use " or ’ as text delimeters so you cane delimte either " or ’

Apsheet doesn’t so you cannot substute a ’ with something else in a string.

[Steve]

Oh, you want to replace an apostrophe. Whoops!

How to Extract an Apostrophe ' from text 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], "' ", "")

[Austin]

Still seems like something that would count as a bug to be fixed? Rather than finding 1 forum post on the matter

[Steve]

It is definitely a bug. As I understand it, the expression parser is an external library, and fixing this bug would require patching the library, which isn’t desirable.

@natalie, can you share any insight here?

[Austin]

Steve:

and fixing this bug would require patching the library, which isn’t desirable.

That sounds like a might break other formulas event which I would definitely rather not have.

[nkadonaga]

Steve:

It is definitely a bug. As I understand it, the expression parser is an external library, and fixing this bug would require patching the library, which isn’t desirable.

@natalie, can you share any insight here?

Austin_Lambeth:

That sounds like a might break other formulas event which I would definitely rather not have.

Yes, fixing the issue is nontrivial due to reasons mentioned above. Please continue to use the suggested workarounds, eg, replace where you intend to use "'" with TRIM("' "). Thanks!

[Food_Courts]

Steve, help me organize this sentence
C001-Bakso2500050007140000 , A004-geprek200005000460000 to
C001-Bakso
25000
5000
7
140000

A004-geprek
20000
5000
4
60000

Please

[Food_Courts]

My Formula is ;

CONCATENATE(
[nama_produk],"
“,[harga_produk],”
“,[discount_harga],”
“,[qty],”
",[sub_total])

[Food_Courts]

And how to remove this " , " from
C001-Bakso2500050007140000 , A004-geprek200005000460000

[Marc_Dillon]

A bug? I thought that’s just how it works.

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…

Quotation marks in a text string 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])

[Austin]

I guess so long as there is A method that’s what really counts.

[PocketSurvey · Accepted solution]

Heres’s one workaround courtesy of @Aleksi

SUBSTITUTE(“Sample’text”,LEFT("’ “,1),”")