UNIX for Dummies Questions & Answers

file names:
 
TEST_HISTORY_MTH.meta
AB_TEST_1.meta
 
cat TEST_HISTORY_MTH.meta
 
                   Table "TEST_HISTORY_MTH"
           Attribute           |     Type      | Modifier | Default Value
-------------------------------+---------------+----------+---------------
 MONTH_ID                      | NUMERIC(6,0)  | NOT NULL |
 ROLE_ID                       | NUMERIC(12,0) | NOT NULL |
 OUTCOME_ID                    | NUMERIC(12,0) | NOT NULL |
 REASON_ID                     | NUMERIC(12,0) | NOT NULL |
 USED_ID                       | NUMERIC(12,0) | NOT NULL |
 TEST_ID                       | NUMERIC(12,0) | NOT NULL |
 CONTACTS                      | NUMERIC(12,0) | NOT NULL |
 OFFER                         | NUMERIC(12,0) | NOT NULL |
 TIME                          | NUMERIC(12,0) | NOT NULL |
 SEQUENCE1                     | NUMERIC(12,0) | NOT NULL |
Constraints:
Name                             Settings
TEST_HISTORY_MTH_PK              Primary key(MONTH_ID,ROLE_ID,OUTCOME_ID,REASON_ID,USED_ID,TEST_ID,CONTACTS,OFFER)
Distributed on random: (round-robin)
 
 
cat AB_TEST_1.meta
 
 
                  Table "AB_TEST_1"
 Attribute |     Type      | Modifier | Default Value
-----------+---------------+----------+---------------
 NAME      | CHARACTER(10) |          |
 EMPNO     | CHARACTER(3)  |          |
 AGE       | NUMERIC(3,0)  |          |
Distributed on hash: "NAME"
 
 
Desired output for each file should be as follows (columns seperated with only one space each):
 
TEST_HISTORY_MTH MONTH_ID ROLE_ID OUTCOME_ID REASON_ID USED_ID TEST_ID CONTACTSOFFER TIME SEQUENCE1
AB_TEST_1 NAME EMPNO AGE

sed -sne '/^ *Table "/{s/[^"]*"//;s/".*//;h;N;N;s/.*//;};/|/!b u;s/ *|.*//;H;:u;${x;s/\n//g;p;}' *.meta