Solaris

Hi,

I have two files. Want to make an addition of the fifth column of from both the files and redirect it to a third file.
Both files have same records except fifth field and same record should be inserted into new file having fifth field as addition of fifth fields of both files.

for example file1 (first record) looks like -
9891005244,sanjay,delhi,sales,30,india

and file2 looks like -
9891005244,sanjay,delhi,sales,60,india

then file3 should have -

9891005244,sanjay,delhi,sales,90,india

Please help.

Should be something like this:

Code:

awk -F, '
NR==FNR{a[$1]+=$5;next}
a[$1]{$5+=a[$1];print}
' OFS="," file1 file2 > file3

Regards

Thanks Franklin.... It worked...