Regex for matching parentheses

Question

I have string : select * from workspace populate $intname(Column 5) with column_1 as lookup [(Office Military,OM)]

In which I want to match $intname(Column 5)

The regex I have written is : \$intname\(.+\)

which matches $intname(Column 5) with column_1 as lookup [(Office Military,OM)

How do I achieve this?

Answer 1

Make the regex non greedy:

\$intname\(.+?\)

or

\$intname\([^)]+\)