Search Results

You will find are many examples of this kind of join operation.. Try:
awk 'NR==FNR{A[$2]=$1; next} $12==1 && $1 in A{$6=A[$1]}1' FS=, OFS=, file2 file1

--edit--
Mornin' Don ;)

The following awk script seems to do what you said you want:
awk '
BEGIN { FS = OFS = ","
}
FNR == NR {
k[$2] = $1
next
}
{ if($12 == 1 && $1 in k) $6 = k[$1]
}
1' file2 file1
But, with...