Search Results

Hi , Try this,

awk 'NR==FNR{a[$1FS$2]=$3FS$4;next} { if ($1FS$2 in a) { print $0,a[$1FS$2];delete a[$1FS$2]} else {print $0}} END{for (i in a) { print i,FS,FS,a[i]}}' file2 file1

Try this,


awk 'NR==FNR{a[$1FS$2]=$3FS$4;next} { if ($1FS$2 in a) { print $0,a[$1FS$2];delete a[$1FS$2]} else {print $0}} END{for (i in a) { print i,a[i]}}' file2 file1

Untested:

awk 'END {
for (r in _) print _[r]
}
NR == FNR {
_[$1, $2] = $0; next
}
($1, $2) in _ {
split(_[$1, $2], t); delete _[$1, $2]
print $0, t[3], t[4]
}' file2 file1

Hi, Try this,


awk 'NR==FNR{a[$1$2]=$3FS$4;next} { if ($1$2 in a) { print $0,a[$1$2]} else {print $0}}' file2 file1

Use gawk, nawk or /usr/xpg4/bin/awk on Solaris.

awk 'NR == FNR {
_[$1, $2] = FS $3 FS $4
next
}
$NF = $NF _[$1, $2]
' file2 file1

#!/bin/sh

IRS=" "
num=1
while read var1 var2 var3 var4; do
awk -v var1=${var1} -v var2=${var2} -v var3=${var3} -v var4=${var4} -v num=${num} 'NR>=num{if($1==var1 && $2==var2){ print $0" "var3"...