Shell Programming and Scripting

I have two files which are as follows:
File 1:

Code:

1 abc 250
2 pqr 300
3 xyz 100

File 2:

Code:

1 abc 230
2 pqr 700
3 xyz 500

Now I need output File, File 3as:

Code:

S.No Name Count1 Count2
1 abc 250 230
2 pqr 300 700
3 xyz 100 500

NOTE:
It will be good if you combine based on first field, which are serial numbers, i.e; Compare S.nos from both files, Print Name column from file2 (or file 1, only one), Count 1 from file1, count 2 from file2.

(Because may be there is a little difference in Name fields, but the purpose of both Name fileds are same)

Can any one help me in getting the unix Script for this?

Actually my list will be of 14.


Thanks.

The easiest way to do this is by using, join. Join joins the 2 files based on a specified field, in your case field 1. This is the first time that I am using join myself and this may be one way to do this:

Code:

join -j 1 file1 file2 | awk '{print $1 " " $2 " " $3 " " $5 }'

- GP

Thanks mate....

Actually I came upto Join... but that Awk was not striked for me using Pipe.


Many Thanks!!!

AWK in this case can be avoided by using -o option of join:

Code:

join -j1 -o 1.1,1.2,1.3,2.3 file1 file2

This was not worked for the serial no 10-14 ; which are two digits.
But if i take 1-9 in one file and 10-14 in secon file, then it works.

But if 1-14 are in one single file, then when I use the above syntax it was showing only 1-9 records.

---------- Post updated at 09:12 PM ---------- Previous update was at 09:11 PM ----------


Throwing error:

Usage: join [-a Filenum] [-v Filenum] [-[j] Filenum Fieldnum]
[-t Character] [-o list [-e String] ] File1 File2

Try:

Code:

join -j 1 -o 1.1,1.2,1.3,2.3 file1 file2

Thanks for correcting me in syntax!

Even now also it was showing only 1 to 9 records, what about 10 to 14 records?
How can I get those?

(Which I was discussed above).

Thanks!!!