Extract Base Metadata Expansion

[Erin_Burns]

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

[Stephen_Orr1]

Hi @Erin_Burns,

Give this a try

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