Shell Programming and Scripting

Hi,

Sample Input

Table 1 XXXXX YYYYY
A 1 2 3 4 5
B 1 2 3 4 5
C 1 2 3 4 5
D 1 2 3 4 5
A 6 7
B 6 7
C 6 7
D 6 7
Table 2 XXXXX YYYYY
E 1 2 3 4 5
F 1 2 3 4 5
E 6 7
F 6 7
Table 3 XXXXX YYYYY
G 1 2 3 4 5
H 1 2 3 4 5
I 1 2 3 4 5
G 6 7
H 6 7
I 6 7

Ouptut Should be like below

Table 1 XXXXX YYYYY
A 1 2 3 4 5 6 7
B 1 2 3 4 5 6 7
C 1 2 3 4 5 6 7
D 1 2 3 4 5 6 7
Table 2 XXXXX YYYYY
E 1 2 3 4 5 6 7
F 1 2 3 4 5 6 7
Table 3 XXXXX YYYYY
G 1 2 3 4 5 6 7
H 1 2 3 4 5 6 7
I 1 2 3 4 5 6 7

Please advice.. Please let me know if further details required.

---------- Post updated at 11:22 AM ---------- Previous update was at 10:46 AM ----------

Please help ASAP..

Try this:

Code:

awk -F, '/Table/{for(i in A){print i A[i];delete A[i]};print;next}{sub(/ /,FS);A[$1]=A[$1]" "$2}END{for(i in A)print i A[i]}' infile

Hi Scrutinizer,

Thanks for you reply

can u please modify the script base on the below.
I would like to have the below rows instead of
Table 1 XXXXX YYYYY
Table 2 XXXXX YYYYY
Table 3 XXXXX YYYYY

default data cache Run Size :xxxxx Usage% : yyyy
TDB_DataCache Run Size :xxxxx Usage% : yyyy
cache_* Run Size :xxxxx Usage% : yyyy


also i m gettin the below error when tried with one pattern.

awk -F, '/default data cache/{for(i in A){print i A[i];delete A[i]};print;next}{sub(/ /,FS);A[$1]=A[$1]" "$2}END{for(i in A)print i A[i]}' chumma.txt > chumm.txt
awk: syntax error near line 1
awk: illegal statement near line 1


Please advice..

I don't understand what you mean, could you use code tags? What is YYYY and what is yyyy. Also, did you try something yourself?
Use nawk or /usr/xpg4/bin/awk if on Solaris.

Thanks i used nawk but got some problem, this is the command i tried for my actual input file.

nawk -F, '/Run Size/{for(i in A){print i A[i];delete A[i]};print;next}{sub(/ /,FS);A[$1]=A[$1]" "$2}END{for(i in A)print i A[i]}' chumma.txt > chumm.txt


but the output is something like this
Table 1 XXXXX YYYYY
A 1 2 3 4 5 B 1 2 3 4 5 C 1 2 3 4 5 D 1 2 3 4 5 A 6 7 B 6 7 C 6 7 D 6 7
Table 2 XXXXX YYYYY
E 1 2 3 4 5 F 1 2 3 4 5 E 6 7 F 6 7