Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Extracting String Between ""

Topic Labels: Formulas
126 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.