
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 04, 2022 06:36 AM
Hi everyone, Can someone help me with formula Regex_extract. In Airtable I have a field with text in quotes: " “msg”: “2. Have a second version of that same photo with no background”" .
I can’t get rid of the quotes with formula REGEX_EXTRACT.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 04, 2022 07:26 AM
Do you just want to remove the quotes?
You could do that with the SUBSTITUTE() function:
SUBSTITUTE({Field Name}, "\"", "")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 04, 2022 09:15 AM
Scott nailed it. That aside, it appears that you’re misunderstanding the purpose of REGEX_EXTRACT()
. It’s not designed to selectively remove text from a string and give you what’s left. That what SUBSTITUTE()
and REGEX_REPLACE()
do. REGEX_EXTRACT()
is designed to find text matching a pattern and extract the first such match.
