PowerShell: defining multiple conditions in Where-Object

Question

I have a sample array and I try to create a rule which will filter our either of the 2 items that are present in the array.

Sample array:

$d_c_arr = @('idata', 'quanthouse', 'reuters', 'bloomberg', 'fidelity', 'nasdaq')

The items that I want to filter out are 'idata' and 'quanthouse'.

The filtering rule should adapt to the situations where either both 'idata' and 'quanthouse' exist or only one of them is present in an array.

My attempt to define the rule:

$d_c_arr | Where-Object { $_ -notlike 'idata' -or $_ -notlike 'quanthouse' }

My expected output would be:

reuters
bloomberg
fidelity
nasdaq

However, the actual output is:

idata
quanthouse
reuters
bloomberg
fidelity
nasdaq

How to properly define the rule which would filter either of the 2 selected items in the array?

sandthorn · Accepted Answer · 2020-10-18 15:42:56Z

1

$d_c_arr | sls -pattern 'idata|quanthouse' -notmatch

Your object are .net strings so can use select-string cmdlet.
select-string takes regex as its pattern.

answered Oct 18, 2020 at 15:42

sandthorn

2,8981 gold badge21 silver badges74 bronze badges

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

1 Answer 1