Search Results

awk 'NR == FNR {
key[$1, $2] = $3; next
}
$2 = $2 OFS key[$1, $2]
' OFS=\\t b.txt a.txt

Below code works exactly as you want.but a.txt should be like
A.txt.
grectec; 10 ,53, 60, base_123 ; top09
grectec; 30 ,50, 60, base_123 ; top09
grectec; 30 ,55, 60, base_123 ; top09
grectec; 50...

awk > C.txt 'NR == FNR {
b[$1] = $2; next
}
$0 = $0 FS b[$2]
' B.txt A.txt

Hi all,
I searched through the forum but i can't manage to find a solution. I need to join a set of files placed in a directory (~1600) by column, and obtain an output with first and second column...