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 | |
34 | |
27 | |
23 | |
18 |