Shell Programming and Scripting

hello gurus ,


i want to merge different column from two different file. file struture is below.

file 1
-------



~information is given


Name class section
A 5 b
B 7 C
D 8 A


file 2
------


~information is given


Name grandtotal
A 20
B 30
D 15


in both the files data will come after "~information is given" and i want a result like

file3
-----
Name class section grandtotal

A 5 b 20
B 7 C 30
D 8 A 15


Any help is highly appericiated

Thanks
Rahul

Seems to be more of a Home work que...

Guideline...

Cut the field and paste it into the other file...
i.e make use of cut ....paste filters...

Granting that the two files have a common field in each line, I guess the join utility will solve your problem.


EDIT: join can make it but for your requirements it will need a lot of work than using cut and paste as suggested by shiv.

Code:

$ cat file1
A 5 b
B 7 C
D 8 A

$ cat file2
A 20
B 30
D 15


join -1 1 -2 1 file1 file2
A 5 b 20
B 7 C 30
D 8 A 15

[ "-1 1" indicates join on 1st field of 1st file i.e file1 to " -2 1" 1st field of 2nd file i.e file2 ]

Code:

awk 'NR==FNR{a[$1]=$2;next}$4=a[$1]' file2 file1 > file3

I try to keep things simple. I am a novice user at best. Still lots to learn. But this this OS, any nix flavor, I try to keep the mentality "keep it simple stupid" and have one of those log blue log books that house command line, perl and ksh solutions that I have either figured out, read someplace or picked up from more advanced friends on forums like this ... it is gold to me and I keep it under lock and key ...

So with that in mind .. why not

pr -t -m file1 file2 > file3

Did you check the output?