Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Extracting String Between ""

Topic Labels: Formulas
127 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello!

I have seen similar posts but cannot seem to get them to work. I have the following string of text:

New voicemail in mailbox 1 from “AWESOME DUDE” <555-555-5555>

I am trying to extract AWESOME DUDE and 555-555-5555 to seperate cells.

I have tried the solution suggested here but cannot seem to get it to function, as it returns a
-1.

Any assistance would be greatly appreciated.

1 Reply 1

Hi Benson, try the following two formulas:

Person Name:
REGEX_EXTRACT({Name}, '"(.*)"')

Phone Number:
REGEX_EXTRACT({Name}, '<(.*)>')

Screenshot 2022-08-28 at 3.30.05 PM

And here’s a link to the base. You can duplicate the base to view the formulas within the base itself.