Comparing array of objects in Powershell

Question

I have two different objects in Powershell:

One is using a "Project" class instantiated with New-Object. Each of these contain 2 properties.
The second one is just an array of strings.

Now, I would like to remove the projects in the array of Project that are not in the second array.

For, instance. In Linq, I would do something like this:

var result = from item in arrayOfStrings
             from project in arrayOfProjects
             where project.Property2 == item
             select project;

This query would get me anything in the first list that is not in the second one.

What I have tried without success:

$result = $projects | Where-Object { $_.Property2 -eq $arrayOfStrings | Select-Object }

Thank you

Edit

The class looks like this:

public class Project
{
    public string Name {get; set;}
    public string Guid {get; set;}
}

The second array is just filled with some Guids. I want to get a $queryResult with the Projects that are in the second array.

Can you not edit the question and show the structure of the objects? Hard to know what you're asking otherwise. However, I don't think you'll need the final Select-Object, there Where-Object will do the "select" — arco444
– arco444, Commented Jul 23, 2015 at 14:55
I added the class in the edit. Yes, I guess I won't need it. But, I am not too familiar with Powershell — Luis Lavieri
– Luis Lavieri, Commented Jul 23, 2015 at 14:58

dugas · Accepted Answer · 2015-07-23 15:17:44Z

5

$projects | Where-Object { $arrayOfStrings -Contains $_.Name }

Or using the "in" operator:

$projects | Where-Object { $_.Name -in $arrayOfStrings }

edited Jul 23, 2015 at 15:17

answered Jul 23, 2015 at 15:07

dugas

12.6k3 gold badges48 silver badges54 bronze badges

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

2 Comments

Matt Over a year ago

Note that -in started in PowerShell version 3.

Luis Lavieri Over a year ago

Thanks so much to both of you

Collectives™ on Stack Overflow

Comparing array of objects in Powershell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related