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
Solved! Go to Solution.
Heres’s one workaround courtesy of @Aleksi
SUBSTITUTE(“Sample’text”,LEFT("’ “,1),”")
Hi, did you try that ?
SUBSTITUTE( “\’”, “_”)
Just an idea…
Does not work
Need the column you want to SUBSTITUTE the value in.
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.
Oh, you want to replace an apostrophe. Whoops!
Still seems like something that would count as a bug to be fixed? Rather than finding 1 forum post on the matter
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?
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!
Steve, help me organize this sentence
C001-Bakso2500050007140000 , A004-geprek200005000460000 to
C001-Bakso
25000
5000
7
140000
A004-geprek
20000
5000
4
60000
Please
My Formula is ;
CONCATENATE(
[nama_produk],"
“,[harga_produk],”
“,[discount_harga],”
“,[qty],”
",[sub_total])
And how to remove this " , " from
C001-Bakso2500050007140000 , A004-geprek200005000460000
A bug? I thought that’s just how it works.
I guess so long as there is A method that’s what really counts.
Heres’s one workaround courtesy of @Aleksi
SUBSTITUTE(“Sample’text”,LEFT("’ “,1),”")
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |