I have to do a recursive search for a word and then select the line/lines until the ).
My file looks like below and the output is mentioned below.

SET var1 = FormatValue(A1,B1,B2); 
SET var2 = FormatValue(X1, 
X2, 
X3); 
DEFINE VAR3; 
SET var4 = FormatValue(z1,z2,
z3);

i want to search for all lines containing ‘set’ and also up until the closing bracket ‘)’ I want the output to be

SET var1 = FormatValue(A1,B1,B2); 
SET var2 = FormatValue(X1, X2, X3); 
SET var4 = FormatValue(z1,z2, z3);