
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 31, 2021 12:40 PM
Is there a formula I can use to replace, say, " with " ? I find myself often having to go in and do this manually. Thanks in advance for your suggestions! :slightly_smiling_face:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2021 10:21 AM
If you want to make multiple changes to some text using several SUBSTITUTE()
functions, you’ll need to nest them inside each other. Your second attempt threw an error because you didn’t get the nesting set up correctly. Instead of each SUBSTITUTE()
operating on the original content, the outer ones need to operate on the results of the inner ones, like this:
SUBSTITUTE(SUBSTITUTE({Excerpt}, '--', '—'), '"', '"')
Nested functions always work from the inside out. In this case, it first swaps out double-dashes in the original content for an em dash, and then that result is processed to fix the quotes.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 31, 2021 05:58 PM
The items you’re replacing didn’t come through. Here’s what I see:
Are you trying to replace quotes? Both of those look the same. Can you describe what you want to do in greater detail?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 31, 2021 08:50 PM
Attempt number three:
I want &-q-u-o-t-; replaced by "
Maybe spelling it out like a swear word will work?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 31, 2021 08:54 PM
Success! :grinning_face_with_big_eyes:
This is fairly easy using the SUBSTITUTE()
function:
SUBSTITUTE({HTML Field}, """, '"')
FWIW, what I just did there is a great way to force the forum to honor whatever you type: turn it into preformatted text using the </>
item in the editor toolbar. For multiple lines of text, wrap them in pairs of graves triplets (the grave is this: ` — it shares the key with the tilde ~ symbol). With that, this:
```
Testing 123
```
…becomes…
Testing 123

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2021 10:05 AM
Thanks! That formula worked for the quotation mark, but not for additional adjustments that needed to be made. Here’s how I tweaked it to take on one of those additional adjustments:
Attempt Number 1:
SUBSTITUTE({Excerpt}, '"', '"') & SUBSTITUTE({Excerpt}, '--', '—')
Attempt Number 2
SUBSTITUTE({Excerpt}, '"', '"', SUBSTITUTE({Excerpt}, '--', '—'))
The first attempt didn’t make the dashes/bar adjustment, and the second attempt returned an error message. And I always wondered about the preformatted text thing! :slightly_smiling_face:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2021 10:21 AM
If you want to make multiple changes to some text using several SUBSTITUTE()
functions, you’ll need to nest them inside each other. Your second attempt threw an error because you didn’t get the nesting set up correctly. Instead of each SUBSTITUTE()
operating on the original content, the outer ones need to operate on the results of the inner ones, like this:
SUBSTITUTE(SUBSTITUTE({Excerpt}, '--', '—'), '"', '"')
Nested functions always work from the inside out. In this case, it first swaps out double-dashes in the original content for an em dash, and then that result is processed to fix the quotes.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2021 10:24 AM
Perfect! Thanks, Justin! :grinning:
