从另一个文件中查找电子邮件

I want to find emails from one file listed as such:

我想从一个列出的文件中找到电子邮件:

[e-mail]
[e-mail]
[e-mail]

in another file listed as so:

在另一个文件中列出如下:

[e-mail]:[phone]
[e-mail]:[phone]
[e-mail]:[phone]
[e-mail]:[phone]

and output the lines from the second file that match with the first file also keeping in mind it needs to match the entire email from start to finish so it won't match [e-mail] accidently.

并输出第二个文件中与第一个文件匹配的行,同时记住它需要从头到尾匹配整个电子邮件,因此它不会与[e-mail]意外匹配。

Desired output:

[e-mail]:[phone]
[e-mail]:[phone]

Thanks!

1 个解决方案

#1

With grep, get the newline separated patterns (strings here, -F) from an input file with -f, and match with the other file:

使用grep,使用-f从输入文件中获取换行符分隔的模式(字符串,-F),并与另一个文件匹配:

grep -Ff email.txt file.txt 

---

With awk, keeping an array with emails as indexes and checking if the first field of each record in the second file is an index:

使用awk,使用电子邮件作为索引保持数组,并检查第二个文件中每个记录的第一个字段是否为索引:

awk -F: 'NR==FNR{a[$0]=1; next} a[$1]' email.txt file.txt

---

Example:

% cat email.txt 
[e-mail]
[e-mail]
[e-mail]

% cat file.txt
[e-mail]:[phone]
[e-mail]:[phone]
[e-mail]:[phone]
[e-mail]:[phone]

% grep -Ff email.txt file.txt 
[e-mail]:[phone]
[e-mail]:[phone]


% cat email.txt                                                  
[e-mail]
[e-mail]
[e-mail]

% cat file.txt
[e-mail]:[phone]
[e-mail]:[phone]
[e-mail]:[phone]
[e-mail]:[phone]

% awk -F: 'NR==FNR{a[$0]=1; next} a[$1]' email.txt file.txt
[e-mail]:[phone]
[e-mail]:[phone]