Search Results

$ awk 'NR==FNR { C[$1]++; L[$1, C[$1]]=$0; D[$1, C[$1]]=$2 ; next }
C[$1] { for(N=1; N<=C[$1]; N++) if(D[$1, N]==$3) print L[$1, N], $0 }' file1 file2

1334 10 0 0 1 5.2 1334 14 10 0 2 5.5
1340...

$ awk 'NR==FNR{D[$1]=$0}; (NR!=FNR) && D[$1] && (!S[$1]++) { print D[$1], $0 }' file1 file2

1334 12 0 0 1 4.5 1334 14 10 0 2 5.5
1340 11 0 0 1 3.5 1340 8 11 0 1 5.6

$

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read...