linux - awk 的多输入文件

Question

我有两个 CSV 文件，第一个如下所示:

文件 1:

3124,3124,0,2,,1,0,1,1,0,0,0,0,0,0,0,0,1106,11
6118,6118,0,0,,0,0,1,0,0,0,0,1,1,1,1,1,5156,51
6679,6679,0,0,,1,0,1,0,0,0,0,0,1,0,1,0,1106,11
5249,5249,0,0,,0,0,1,1,0,0,0,0,0,0,0,0,1106,13
2658,2658,0,0,,1,0,1,1,0,0,0,0,0,0,0,0,1197,11
4322,4322,0,0,,1,0,1,1,0,0,0,0,0,0,0,0,1307,13

文件 2:

7792,1307,2012-06-07,,,,
5249,4001,2016-07-02,,,,
6001,1334,2017-01-23,,,,
2658,4001,2009-02-09,,,,
9279,1326,2014-12-20,,,,

我需要的:如果 file2 中的 $2 = 4001，则必须匹配 file2 的 $1对于 file1，如果 $18 in file1 = 1106 对于匹配的 $1 然后打印那条线。

预期输出:

5249,5249,0,0,,0,0,1,1,0,0,0,0,0,0,0,0,1106,13

我已经尝试了以下方法，但没有成功。

awk 'NR=FNR {A[$1]=$1;next} {print $1}'

P.S: 文件是压缩的，所以我必须使用zcat命令

Answer 1

我会尝试这样的事情:

$ cat t.awk
BEGIN { FS = "," }

# Processing first file
NR == FNR && $18 == 1106 { a[$1] = $0; next }

# Processing second file
$2 == 4001 && $1 in a { print a[$1] }


$ awk -f t.awk file1.txt file2.txt
5249,5249,0,0,,0,0,1,1,0,0,0,0,0,0,0,0,1106,13