How to SUBSTUTITE a '?

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 Solved
0 16 1,153
1 ACCEPTED SOLUTION

Heres’s one workaround courtesy of @Aleksi

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

View solution in original post

16 REPLIES 16
Top Labels in this Space