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 any work around available?
Sample
SUBSTITUTE([NAME],""","!")
Example field:
ALPHA-"-BETA
Expectation:
ALPHA-!-BETA
comments are welcome
Solved! Go to Solution.
@prashgames
How about this:
SUBSTITUTE([NAME],"_"_","_!_")
Expression ‘SUBSTITUTE([NAME],""","!")’ could not be parsed due to exception: Unterminated string.
Try:
SUBSTITUTE([NAME], '"', "!")
SUBSTITUTE([Instagram Name],’"’, “”!")
SUBSTITUTE([Instagram Name],’"""’, “”)
both above format works… (’ " ') & (" “” ")
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |