UNIX and Linux Forums - Search Results

Showing results 1 to 2 of 2 Search took 0.01 seconds. Search: Posts Made By: murpholinox

Forum: Shell Programming and Scripting 06-06-2011

Add fields in different files only if some fields between them match

2,901

Posted By

You will get file "not.match.txt" automatically. ...

You will get file "not.match.txt" automatically.

awk 'NR==FNR{a[$1 FS $2]=$3;b[$1 FS $2]=$4;next}
{ if (a[$1 FS $2]!="") {$3=a[$1 FS $2]+$3; $4=b[$1 FS $2]+$4;print}
else {print >...

Forum: Shell Programming and Scripting 06-06-2011

Add fields in different files only if some fields between them match

2,901

Posted By

awk 'NR==FNR{a[$1 FS $2]=$3;b[$1 FS $2]=$4;next} ...

awk 'NR==FNR{a[$1 FS $2]=$3;b[$1 FS $2]=$4;next}
a[$1 FS $2]!="" {$3=a[$1 FS $2]+$3; $4=b[$1 FS $2]+$4;print}' FS=, OFS=, file1 file2

Showing results 1 to 2 of 2