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 — user6811411
– user6811411, Commented Nov 27, 2018 at 15:57
$File1 | Where {$File2 -Contains $_}, see also: stackoverflow.com/a/35872835/1701026 — iRon
– iRon, Commented Nov 27, 2018 at 16:02

vrdse · Accepted Answer · 2018-11-27 17:35:01Z

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, 2018 at 17:35

vrdse

3,24413 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Razorfen · Accepted Answer · 2018-11-27 17:14:13Z

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, 2018 at 17:14

answered Nov 27, 2018 at 17:06

Razorfen

4335 silver badges12 bronze badges

Collectives™ on Stack Overflow

Powershell Compare-Object output to file

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related