Search Results

That is correct.

awk 'END {
for (i = 0; ++i <= FNR;)
print r[i]
}
NR == FNR {
f[$1] = substr($0, index($0, $2))
next
}
{
for (i = 0; ++i <= NF;)
$i in f && r[FNR] = (r[FNR] ? r[FNR] :...

Another way.

awk 'NR==FNR{c[$1 FS $2];next} {a[$1]=a[$1] FS $2 FS $3}
END{for ( i in c) {split(i,x,FS);if (x[1]!=x[2]) print i,a[x[1]],a[x[2]]}}' file1 file2

nawk 'NR==FNR{A[$3]=$5;next}{print $0 (($4 in A)?FS A[$4]:z)}' file1 file2

---------- Post updated at 07:27 PM ---------- Previous update was at 07:26 PM ----------

$ cat f1
john doe 123 left...

awk 'NR==FNR{a[$3]=$5;next}{print $0,a[$4]}' file1 file2

awk 'END {
for (i = 0; ++i <= FNR;)
if (i in r) print r[i]
}
NR == FNR {
f[$1] = substr($0, index($0, $2))
next
}
$1 != $2 {
for (i = 0; ++i <= NF;)
$i in f && r[FNR]...