Skip to main content

Extract a name from Parentheses

  • June 13, 2023
  • 1 reply
  • 10 views

Forum|alt.badge.img+1

Hello! I am trying to extract text from within Parentheses and can't get the Regex formula quite right. The data comes in like this:

Highrise Intro (First Last)

I want to extra First Last and eliminate the rest.

 

Thanks

1 reply

Forum|alt.badge.img+18
  • Inspiring
  • 272 replies
  • June 13, 2023

Hi @Erin_Burns,

Give this a try

REGEX_EXTRACT({some_field},'\\((.*?)\\)')