David "pipelinedave" Hallmann pipelinedave

✨

manifesting the desired state

finding creative ways of making the machines do the busywork

pipelinedave / Get-Duplicates.ps1

Last active May 15, 2020 13:56

powershell / Get duplicates from a csv file

	$data = Import-Csv -path .\test.csv

	$unique = $data \| Select-Object -Unique

	$data \| Where-Object { $_ -notcontains $unique }

	Compare-Object -ReferenceObject $data -DifferenceObject $unique -IncludeEqual \| Where-Object { $_.SideIndicator -eq "==" } \| Select-Object -ExpandProperty InputObject

	$data = Import-Csv -path .\test.csv

	$unique = $data \| Select-Object -Unique

	$data \| Where-Object { $_ -notcontains $unique }

	Compare-Object -ReferenceObject $data -DifferenceObject $unique -IncludeEqual \| Where-Object { $_.SideIndicator -eq "==" } \| Select-Object -ExpandProperty InputObject