Help

Extracting String Between ""

Topic Labels: Formulas
558 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Benson_G_Munyan
4 - Data Explorer
4 - Data Explorer

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.