Extraction of data between parenthesis using multiple pattern

UNIX for Beginners Q & A
1 
i want to extract all data with in parenthesis  from a file by passing a pattern from another file.i have some sql statements in my file and i want to extract those ddl by refering to a pattern which is in another file and before writting into file i need some transformation to do.Basically i want to do this in While/FOR loop

Pattern file:

ABC
XYZ

SRC FILE:

CREATE TABLE ABC
(
A,
B,
C
);

CREATE TABLE XYZ
(
X
);

SO NOW I WANT TO CHECK/PASS THE 1ST PATTERN AND IF MATCHES WHICH IS MATCHING IN SRC FILE THEN I WANT TO EXTRACT DATA WHICH ARE INSIDE PARENTHESIS.desired o/p below:
A,
B,
C

SAME WAY WHEN THE 2ND PATTERN WILL COME IT FOUND THE MATCHING IN SRC FILE AND OUTPUT WRITES IN TO OUTPUT FILE WHICH IS 

A

I WANT TO DO THIS IN LOOP(WHILE/FOR) IN ORDER TO MAKE SOME IN BETWEEN TRANSFORMATION BEFORE WRITING TO OUTPUT FILE.

HOPE THIS HELPS
2

Registering with another member name after having been set to read only due to four forum rule infractions (after several more gentle reminders) won't fly. This thread is closed; user banned.

2 Likes