capture value within the parentheses using function

[jenim514]

Hi!  

I have values that look like this:

VAR_NAME

(3) left hearing 12JAN2017

(14) right hearing 30JAN2017

The only thing i need to capture from this value are the numbers within the parentheses.  Can someone help me use a scan or substr to capture this (or other function) ?

Thanks!

[novinosrin]

if the pattern is exactly the same as your sample-

new_var=compress(scan(var_name, 1), '()');

[Reeza · Accepted solution]

new_var=scan(var_name, 1, '()');