RegEx to keep all text in brackets

[chayes]

Hi All

I use this RegEx in an action to remove everything in brackets in the COMMENT Column :

Field : COMMENT

Regular Expression : (.*?)\s*\(.*\)

Replace Matches With : $1

This works fine and removes all text in brackets , including the brackets themselves.

I'm trying now to have the expression KEEP everything in brackets and remove the rest of the phrase.

So

piano pieces(paul crossley)
piano distance (yuji takahashi)
orion (tsuyoshi tsutsumi, seiko seki)
in the woods (kiyoshi shomura)

Would become

paul crossley
yuji takahashi
tsuyoshi tsutsumi, seiko seki
kiyoshi shomura

Can someone suggest some RegEx to satisfy this?

Grateful for any advice.

[LyricsLover]

You could try this regular expression:
.*\((.*)\)
Replace with $1

This regular expression only works if there is only one pair of brackets at the end of your string. It would not work for
(another) piano pieces (paul crossley)

[chayes]

Hi LyricsLover - Many Thanks. That's working perfectly.