Where-Object filter selection using string array

Question

I have a custom object with the Properties: Name, Value and others.

I'm trying to filter using Where by the name property, using an array:

$NamesToExclude= @('Person1', 'Person2', 'Person3', 'Person4')

$CustomObj | Where-Object {$_.Name -ne $NamesToExclude}

This returns all excluded names (and others). I have also tried:

{$_.Name -ne $($NamesToExclude)}

and tried using the -notlike operator. What am I doing wrong?

G42 · Accepted Answer · 2018-02-06 11:38:01Z

3

You have an [Array] but are using it like a [String]

Instead of -notlike or -ne, use -notin:

$CustomObj | Where-Object {$_.Name -notin $NamesToExclude}

about_Operators goes into more detail.

answered Feb 6, 2018 at 11:38

G42

10.1k2 gold badges22 silver badges36 bronze badges

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

Comments

gvee · Accepted Answer · 2018-02-06 11:36:59Z

0

Have a go with -notin!

$CustomObj | Where-Object {$_.Name -notin $NamesToExclude}

answered Feb 6, 2018 at 11:36

gvee

17.2k42 silver badges50 bronze badges