Regex get everything after specific matched parenthesis based on value inside them

So I have a list of vinyl records that I own, and I am trying to remove some text from their results off of discog, the strings can look something like this;

Artist - Title (12") (Warner Bros - WB1210)  Artist - Title (12", Promo) (Warner Bros - WB1212)  Artist - Title (Summer Mix) (12", Promo) (Warner Bros - WB1444)  Artist - Title (12", LP Album) (Warner Bros- - WB9449)  Artist - Title (12", Red) (Warner Bros - WB1211)  

I want to remove the last set of parenthesis so they read;

Artist - Title (12")  Artist - Title (12", Promo)  Artist - Title (Summer Mix) (12", Promo)  Artist - Title (12", LP Album)  Artist - Title (12", Red)  

I have tried this regex pattern, with no luck;

(?<=\(12"(.*)\)[ ]).*  

If I just use (?<=(12").) everything after 12" is highlighted, so I assumed add (.)) would get everything between 12" and the closing parenthesis, obviously it is not. Any ideas?

https://stackoverflow.com/questions/66575085/regex-get-everything-after-specific-matched-parenthesis-based-on-value-inside-th March 11, 2021 at 09:06AM