匹配第三场在CSV与GNU Linux的图形文件（AWK / SED / GREP） [英] Matching third field in a CSV with pattern file in GNU Linux (AWK/SED/GREP)

问题描述

我要打印CSV文件的所有行，当第3场模式文件中的模式相匹配。

I need to print all the lines in a CSV file when 3rd field matches a pattern in a pattern file.

我已经试过的grep没有运气，因为它与任何领域匹配，不仅在第三。

I have tried grep with no luck because it matches with any field not only the third.

grep -f FILE2 FILE1 > OUTPUT

文件1

dasdas,0,00567,1,lkjiou,85249
sadsad,1,52874,0,lkjiou,00567
asdasd,0,85249,1,lkjiou,52874
dasdas,1,48555,0,gfdkjh,06793
sadsad,0,98745,1,gfdkjh,45346
asdasd,1,56321,0,gfdkjh,47832

文件2

00567
98745
45486
54543
48349
96349
56485
19615
56496
39493

右输出

dasdas,0,00567,1,lkjiou,85249
sadsad,0,98745,1,gfdkjh,45346

输出错误

dasdas,0,00567,1,lkjiou,85249
sadsad,1,52874,0,lkjiou,00567   <---- I don't want this to appear
sadsad,0,98745,1,gfdkjh,45346

我已经找遍和尝试不同的配方。

I have already searched everywhere and tried different formulas.

编辑：感谢Wintermute，我设法写的东西是这样的：

thanks to Wintermute, I managed to write something like this:

csvquote file1.csv > file1.csv
awk -F '"' 'FNR == NR { patterns[$0] = 1; next } patterns[$6]' file2.csv file1.csv | csvquote -u > result.csv

Csvquote有助于解析CSV文件，AWK。

Csvquote helps parsing CSV files with AWK.

非常感谢大家，伟大的社会！

Thank you very much everybody, great community!

推荐答案

通过awk的：

awk -F, 'FNR == NR { patterns[$0] = 1; next } patterns[$3]' file2 file1

这个工作原理如下：

FNR == NR {           # when processing the first file (the pattern file)
  patterns[$0] = 1    # remember the patterns
  next                # and do nothing else
}
patterns[$3]          # after that, select lines whose third field
                      # has been seen in the patterns.

这篇关于匹配第三场在CSV与GNU Linux的图形文件（AWK / SED / GREP）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！