plz help in writing awk script
hi buddies
pls help in this matter
i have file like this input file
--------------------------
(PARTITION PARTITION_1 VALUES LESS THAN (101, 16383 ) TABLESPACE PART_1
,PARTITION PARTITION_2 VALUES LESS THAN (101, 32766 ) TABLESPACE PART_2
,PARTITION PARTITION_3 VALUES LESS THAN (101, 49149 ) TABLESPACE PART_3
,PARTITION PARTITION_4 VALUES LESS THAN (101, 65535 ) TABLESPACE PART_4
,PARTITION PARTITION_3 VALUES LESS THAN (101, 49149 ) TABLESPACE PART_3
,PARTITION PARTITION_4 VALUES LESS THAN (101, 65535 ) TABLESPACE PART_4
,PARTITION PARTITION_5 VALUES LESS THAN (102, 16383 ) TABLESPACE PART_5
,PARTITION PARTITION_6 VALUES LESS THAN (102, 32766 ) TABLESPACE PART_6
,PARTITION PARTITION_7 VALUES LESS THAN (102, 49149 ) TABLESPACE PART_7
,PARTITION PARTITION_8 VALUES LESS THAN (102, 65535 ) TABLESPACE PART_8 ) ;
i need out file like this:
---------------------
(PARTITION PARTITION_1 VALUES LESS THAN (101, 4095 ) TABLESPACE PART_1
,PARTITION PARTITION_2 VALUES LESS THAN (101, 8191 ) TABLESPACE PART_2
,PARTITION PARTITION_3 VALUES LESS THAN (101, 12287 ) TABLESPACE PART_3
,PARTITION PARTITION_4 VALUES LESS THAN (101, 16383 ) TABLESPACE PART_4
,PARTITION PARTITION_5 VALUES LESS THAN (101, 20478 ) TABLESPACE PART_5
,PARTITION PARTITION_6 VALUES LESS THAN (101, 24574 ) TABLESPACE PART_6
,PARTITION PARTITION_7 VALUES LESS THAN (101, 28670 ) TABLESPACE PART_7
,PARTITION PARTITION_8 VALUES LESS THAN (101, 32766 ) TABLESPACE PART_8
,PARTITION PARTITION_9 VALUES LESS THAN (101, 36861 ) TABLESPACE PART_9
,PARTITION PARTITION_10 VALUES LESS THAN (101, 40957 ) TABLESPACE PART_10
,PARTITION PARTITION_11 VALUES LESS THAN (101, 45053 ) TABLESPACE PART_11
,PARTITION PARTITION_12 VALUES LESS THAN (101, 49149 ) TABLESPACE PART_12
,PARTITION PARTITION_13 VALUES LESS THAN (101, 53245 ) TABLESPACE PART_13
,PARTITION PARTITION_14 VALUES LESS THAN (101, 57342 ) TABLESPACE PART_14
,PARTITION PARTITION_15 VALUES LESS THAN (101, 61438 ) TABLESPACE PART_15
,PARTITION PARTITION_16 VALUES LESS THAN (101, 65535 ) TABLESPACE PART_16
,PARTITION PARTITION_17 VALUES LESS THAN (102, 4095 ) TABLESPACE PART_17
,PARTITION PARTITION_18 VALUES LESS THAN (102, 8191 ) TABLESPACE PART_18
,PARTITION PARTITION_19 VALUES LESS THAN (102, 12287 ) TABLESPACE PART_19
,PARTITION PARTITION_20 VALUES LESS THAN (102, 16383 ) TABLESPACE PART_20
,PARTITION PARTITION_21 VALUES LESS THAN (102, 20478 ) TABLESPACE PART_21
,PARTITION PARTITION_22 VALUES LESS THAN (102, 24574 ) TABLESPACE PART_22
,PARTITION PARTITION_23 VALUES LESS THAN (102, 28670 ) TABLESPACE PART_23
,PARTITION PARTITION_24 VALUES LESS THAN (102, 32766 ) TABLESPACE PART_24;