Shell Programming and Scripting

Hi all,
I have automated a process of doing a sanity check for the DDL created by other DBA's. But i am stuck at a point.

while reading a file in the awk, PI of the table is defined as

Code:

)PRIMARY INDEX test_abc(ACCT_ID)
PARTITION BY RANGE_N(AUTHZN_MTCH_IND  BETWEEN DATE '2011-10-01' AND DATE '2012-12-31' EACH INTERVAL '1' MONTH, NO RANGE);

I need to extract the ACCT_ID field. If every one coded in the same way my life would have been easy. But some code it as :

Code:

)PRIMARY INDEX test_abc
                (
                 ACCT_ID
                )
PARTITION BY RANGE_N(AUTHZN_MTCH_IND  BETWEEN DATE '2011-10-01' AND DATE '2012-12-31' EACH INTERVAL '1' MONTH, NO RANGE);

and others can code it any different ways added extra spaces or new line characters, and database accepts it without any issue. My problem is i have to extract the ACCT_ID column and assign it to a variable in my awk. since i am not a unix expert , i am not sure how to do muti-line pattern search. Appreciate your inputs on how to extract the ACCT_ID alone (This is an example, not all scripts have ACCT_ID it could be a different column name).

Perhaps the following snippet will be of some assistance:

Code:

/PRIMARY +INDEX/ {
    s = $0
    while (!match(s, /PRIMARY +INDEX[^(]*\([^)]*\)/)) {
        getline t
        s = s t
    }
    $0 = s
    sub(/.*PRIMARY +INDEX[^(]*\([ \t\n]*/, "", s)
    sub(/[ \t\n]*\).*, "", s)
    print "ACCOUNT ID: " s
}

When it finds a line that contains the word PRIMARY followed by space(s) and the word INDEX, it will append lines (if necessary) until a parenthesized expression is found. The contents of that parenthetical, minus leading and trailing whitespace (space/tab/newline), are extracted.

Regards,
Alister