Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Help with REGEX_EXTRACT

Topic Labels: Formulas
318 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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.