Match first fields of two tab separated files and print matching values

Question

I have two files.

Match the 1st column of first file to 1st column of second file and print entire line of the second file.

Second file is a <tab> separated file.

I have tried many awk one liners, but all remove duplicate values. Like A and C here. I want to preserve these.

File 1:

A
B
C
D
A
C

File 2:

A abc
B cde
C abe
D acc

Output:

A abc
B cde
C abe
D acc    
A abc
C abe

cuonglm · Accepted Answer · 2015-04-28 19:54:04Z

4

Try this:

$ awk 'FNR==NR{a[$1]=$0;next};{print a[$1]}' file2 file1
A abc
B cde
C abe
D acc
A abc
C abe

answered Jul 2, 2014 at 2:55

cuonglm

158k41 gold badges342 silver badges420 bronze badges

1 Answer 1