Hello,
Is there an escape character that can be used to insert special characters within a string value in the formula editor?
We have some automation that writes formulas to different fields but we could not find how to escape certain characters, specifically quotation marks.
E.g.
We would like to have something like:
Value = "This is a test string with special "quotes" inside."
However, the "quotes" substring causes a syntax error. We have tried using the typical escape characters/sequences to escape such as backslash \, and triple-quotes.
As a stop-gap, we ended up going with a clunky solution using the Pad() function so now our formula strings look like this:
Value = "This is a test string with special " + Pad("", '"', 1) + "quotes" + Pad("", '"', 1) + "inside."
I could not find any related threads/documentation.
Any feedback is greatly appreciated.
Thank you in advance!
Formula Editor Escape Character
Moderator: Phil Barton
-
- Posts: 1377
- Joined: Wed Jan 15, 2014 3:50 pm
- Location: Raleigh, NC
- Contact:
Re: Formula Editor Escape Character
You can put them inside a string that is surrounded by single quotes.
Code: Select all
value = 'This is a test string with special "quotes" inside.'
Bob Richards, Senior Software Developer, SoftPro