Extracting String Between "" | Airtable Community

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.

Page 1 / 1

Hi Benson, try the following two formulas:

Person Name:

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

Phone Number:

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

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

Sign up