how to substitute double quotes in a field? SUBSTITUTE([COLUMN],“text to search”,“text to replace”) column: columnname text to search is (") double quotation mark " text to replace(exclamation mark) ! I tried 3 double quotes(“”"), but still gets error… how to do this, or is there an…

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

Search and replace double quotes

LeventK June 27, 2020, 10:36am 2

@prashgames
How about this:

SUBSTITUTE([NAME],"_"_","_!_")

Topic		Replies	Views
How to SUBSTUTITE a '? AppSheet Q&A errors , expressions	16	12	November 27, 2021
How to Extract an Apostrophe ' from text AppSheet Q&A expressions	24	20	January 29, 2025
How to remove apostrophe in the word NURUL'AIN AppSheet Q&A expressions	9	1	October 16, 2024