Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help with REGEX_EXTRACT

Topic Labels: Formulas
1435 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Anton1
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2

Do you just want to remove the quotes?

You could do that with the SUBSTITUTE() function:

SUBSTITUTE({Field Name}, "\"", "")

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.