回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个<strong>文件1.csv</strong>,其中的行如下:</p>
<pre><code>adx,999-99-7708
ada,999-99-8101
ad1,999-99-8342
zda,103-54-7013
ad1,999-99-8591
</code></pre>
<p><strong>file2.csv</strong>具有如下行:</p>
<pre><code>1967-05-08,583-50-3833,Trac,Mich,Ewell,3000,Cumming,3830 Man Rid Driv,tracey@gmail.com,(111) 123-4567,0123,GA,339061
1988-03-27,103-54-7013,Mar,Grac,Vea,30004,Au,2549 Walt Wa Apt D1,m@augu.edu,(706) 916-4817,021341,GA,339060
1973-11-16,183-54-5013,Carl,,Thom,30093,Norcross,1021 Ri Rid Drive,,,,,339059
</code></pre>
<p>想要的输出:</p>
<pre><code>1967-05-08,583-50-3833,Trac,Mich,Ewell,3000,Cumming,3830 Man Rid Driv,tracey@gmail.com,(111) 123-4567,0123,GA,339061
1973-11-16,183-54-5013,Carl,,Thom,30093,Norcross,1021 Ri Rid Drive,,,,,339059
</code></pre>
<p>我试过了</p>
<pre><code>awk -F, 'NR==FNR{a[$2]++; next} !a[$2]{print}' file1.txt file2.txt
</code></pre>
<p>它检查file1.txt中的file2.txt副本并删除它们,但仍然获得输出</p>
<pre><code>1967-05-08,583-50-3833,Trac,Mich,Ewell,3000,Cumming,3830 Man Rid Driv,tracey@gmail.com,(111) 123-4567,0123,GA,339061
1988-03-27,103-54-7013,Mar,Grac,Vea,30004,Au,2549 Walt Wa Apt D1,m@augu.edu,(706) 916-4817,021341,GA,339060
1973-11-16,183-54-5013,Carl,,Thom,30093,Norcross,1021 Ri Rid Drive,,,,,339059
</code></pre>
<p>当带有<strong>103-54-7013</strong>的第#2行应移除时。我对awk做了什么错事</p>