Powershell Compare-Object output to file

Question

I have 2 simple text files that I need to compare and output the items that are in BOTH files

Archive.TXT

Active-Job-List.TXT

This will give me an output

$File1 = Get-Content C:\Archive-List.txt
$File2 = Get-Content C:\Active-Job-List.txt



   Compare-Object -ReferenceObject $File1 -DifferenceObject $File2 -IncludeEqual -ExcludeDifferent | Select @{Expression={$_.InputObject}} | Set-Content C:\Diff.txt

of this in the Diff.txt

@{$_.InputObject=10000}
@{$_.InputObject=10001}
@{$_.InputObject=10002}
@{$_.InputObject=10003}
@{$_.InputObject=10005}
@{$_.InputObject=10010}
@{$_.InputObject=10011}

But what I am really looking for is an output of this

How can I filter the results to what I want? Should I Get-Content of the Diff.txt and "trim" out things I don't want or is there a simpler way?

Instead of `Select @{Expression={$_.InputObject}}` use `Select-Object -ExpandProperty InputObject` — , Nov 27 '18 at 15:57
`$File1 | Where {$File2 -Contains $_}`, see also: https://stackoverflow.com/a/35872835/1701026 — iRon, Nov 27 '18 at 16:02

score 4 · Answer 1 · answered Nov 27 '18 at 17:35

4

You need to expand the InputObject property.

Compare-Object -ReferenceObject $File1 -DifferenceObject $File2 -IncludeEqual -ExcludeDifferent | 
    Select-Object -ExpandProperty InputObject | 
    Set-Content C:\Diff.txt

answered Nov 27 '18 at 17:35

vrdse

2,899
10
20

Razorfen · Answer 2 · 2018-11-27T17:14:13.783

2

You could add a -PassThru to your command like so:

Compare-Object -ReferenceObject $File1 -DifferenceObject $File2 -IncludeEqual -ExcludeDifferent -PassThru | Set-Content C:\Diff.txt

edited Nov 27 '18 at 17:14

answered Nov 27 '18 at 17:06

Razorfen

423
4
12

Powershell Compare-Object output to file

2 Answers2