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
Aug 27, 2022 07:02 PM
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.
Aug 28, 2022 12:30 AM
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.