Shell Programming and Scripting

Hello
Please help me to write Shell script.

I want to merge 2 data files . The data files have common columns
The data file A have 3 columns

Host Version Numberof Failuers


The data file B have also 3 coulmns

Host Version NumberofFailuers .


I want to merge A and B file whereHost and version is common column in both files

The file C should contain data of A and B file


Host Version NumberofFailuers A file NumberofFailuersB File .

Before merging it should check whether Host & version of A file should be equal to Host & version of B file For eg :

For A file

Host Version NoofFailuersA
Linux 7.8 15
Sun 8.5 20
Sun 5.6 50

For B file
Host Version NoofFailuersB
Linux 7.8 15
Sun 5.6 34
Red 5.7 30


The Output File C should merge and contain data like this

Host Version NoofFailuersA NofFailuersB
Linux 7.8 15 15
Sun 8.5 20 34
Sun 5.6 50
Red 5.7 30


Please help me

Waiting for help . pls help me

You can do something like this :

Code:

awk '{print $1 "@" $2,$3}' fileA | sort -o fileA_s
awk '{print $1 "@" $2,$3}' fileB | sort -o fileB_s
join fileA_s fileB_s | awk '{sub(/@/," ",$1}' > result_file
rm fileA_s fileB_s