Windows PowerShell：如何比较两个CSV文件并输出仅在文件中的两个行，而不是在两个文件中

Question

我有一个文件 first.csv

name,surname,height,city,county,state,zipCode
John,Doe,120,jefferson,Riverside,NJ,8075
Jack,Yan,220,Phila,Riverside,PA,9119
Jill,Fan,120,jefferson,Riverside,NJ,8075
Steve,Tan,220,Phila,Riverside,PA,9119
Alpha,Fan,120,jefferson,Riverside,NJ,8075

和 second.csv

name,surname,height,city,county,state,zipCode
John,Doe,120,jefferson,Riverside,NJ,8075
Jack,Yan,220,Phila,Riverside,PA,9119
Jill,Fan,120,jefferson,Riverside,NJ,8075
Steve,Tan,220,Phila,Riverside,PA,9119
Bravo,Tan,220,Phila,Riverside,PA,9119

我想比较两个 first.csv 和 second.csv 文件并输出 first的行。

因此， output.csv 应该有

Alpha,Fan,120,jefferson,Riverside,NJ,8075
Bravo,Tan,220,Phila,Riverside,PA,9119

很多类似的问题，但是输出并不是我想要的。

谢谢

Answer 1

$filea = Import-Csv C:\Powershell\TestCSVs\group1.csv
$fileb = Import-Csv C:\Powershell\TestCSVs\group2.csv

Compare-Object $filea $fileb -Property name, surname, height, city, county, state, zipCode | Select-Object name, surname, height, city, county, state, zipCode | export-csv C:\Powershell\TestCSVs\out.csv -NoTypeInformation

我正在使用所有字段来在此处进行比较和排序，但是您可以指定要使用以匹配行的唯一值。

输出

"name","surname","height","city","county","state","zipCode"     
"Bravo","Tan","220","Phila","Riverside","PA","9119"             
"Alpha","Fan","120","jefferson","Riverside","NJ","8075"

Answer 2

获取对称差异（从两个列表中的所有无关）实际上是一个很普遍的用途比较对象。
因此，我添加了此功能（＃30 ） =“ https://www.powershellgallery.com/packages/join” rel =“ nofollow noreferrer”> join-object script / join-object module （另请参阅：在PowerShell中，将两个桌子加入一张桌子的最佳方法是什么？）。

为此，这个特定的问题：

PS C:\> Import-Csv .\First.csv |OuterJoin (Import-Csv .\Second.csv) |Format-Table

name  surname height city      county    state zipCode
----  ------- ------ ----      ------    ----- -------
Alpha Fan     120    jefferson Riverside NJ    8075
Bravo Tan     220    Phila     Riverside PA    9119