Matching two fields between two files AWK

Question

trying to match fields 1,3 to fields 1,2 in another file and print line of second file. First file is tab delimited and second is csv delimited. Unexpected token error?
file1

1 x 12345 x x x

file2

1,12345,x,x,x

script

awk -F',' FNR==NR{a[$1]=$1,$3; next} ($1,$2 in a) {print}' file1 file2 > output.txt

score 3 · Answer 1 · answered Aug 03 '16 at 18:44

3

same idea, but doesn't depend on uniqueness of the first field but the pair instead

$ awk 'NR==FNR{a[$1,$3]; next} ($1,$2) in a' file1 FS=, file2

1,12345,x,x,x

answered Aug 03 '16 at 18:44

karakfa

66,216
7
41
56

beat me to it ++ ;) – sjsam Aug 03 '16 at 18:49
`^1` Nice use of setting FS between files. – Ed Morton Aug 03 '16 at 23:21

score 1 · Answer 2 · edited May 23 '17 at 12:14

1

You almost nailed it !

awk 'NR==FNR{first[$1]=$3;next} $1 in first{if(first[$1]==$2){print}}' file1 FS="," file2

Output

1,12345,x,x,x

Notes

Since the field separator is different for both the files, we have changed it in between files.
This script makes an assumption that the first field of each file is unique, else, the script breaks

^{See [ switching field separator ] in between files.}

edited May 23 '17 at 12:14

Community

1
1

answered Aug 03 '16 at 18:10

sjsam

21,411
5
55
102

1

The switching of FS was classy. ;) – Мона_Сах Aug 03 '16 at 18:30
1

I borrowed the technique from [\[ this \]](http://stackoverflow.com/a/24517482/1620779) answer. – sjsam Aug 03 '16 at 18:31
Still having issues... Do I need to add -F',' argument? – mxttgen31 Aug 03 '16 at 18:48
@mxttgen31 What is the issue? Could you add more sample input and expected output? – sjsam Aug 03 '16 at 18:50
1

the FS="," did it! Thanks! – mxttgen31 Aug 03 '16 at 19:06
@mxttgen31 you may consider accepting the other solution as it doesn't require the first field to be unique – sjsam Aug 03 '16 at 19:10

Matching two fields between two files AWK

2 Answers2