PowerShell - Match multiple string entries in a CSV file

Question

I'm trying to -match more than one string in a CSV file. Sample CSV below:

Hostname,IpAddress,Domain
x200apple300,1.2.3.4,contoso.local
x200banana300,1.2.3.5,contoso.local
x200orange300,1.2.3.6,contoso.local
x200kiwi300,1.2.3.7,contoso.local

Sample code:

$csv = Import-Csv "C:\Files\csvExample.csv"
$csv | Where-Object {$_.Hostname -match "kiwi"}
# All OK. Now match multiple hostnames.

$csv | Where-Object {$_.Hostname -match "kiwi", "orange"}
# Not working.

$csv | Where-Object {$_.Hostname -contains "apple", "banana"}
# Not working

How can I match multiple hostnames in this example? What am I doing wrong.

Jonathon Anderson · Accepted Answer · 2020-06-30 15:35:09Z

3

Match takes a regex expression, so you can use an or operator to filter on multiple values.

$csv = Import-Csv "C:\Files\csvExample.csv"
$csv | Where-Object {$_.Hostname -match "kiwi|orange|banana"}

answered Jun 30, 2020 at 15:35

Jonathon Anderson

1,2181 gold badge10 silver badges27 bronze badges

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

1 Comment

Farbkreis Over a year ago

Or use the -or operator

Bacon Bits · Accepted Answer · 2020-06-30 15:38:16Z

3

The -match operator expects a regex on the right hand side. I'm not sure what $Value -match $A, $B means; it's not documented that I can see and it seems to always return false from my input.

$_.Hostname -contains "apple", "banana" is backwards. You want either {$_.Hostname -in "apple", "banana"} or {"apple", "banana" -contains $_.Hostname}.

answered Jun 30, 2020 at 15:38

Bacon Bits

32.5k6 gold badges64 silver badges79 bronze badges

1 Comment

mklement0 Over a year ago

$Value -match $A, $B stringifies the RHS array, so it is effectively the same as $Value -match "$A $B", which is rarely useful; e.g., 'fo o' -match 'o', 'o' is $true.

Collectives™ on Stack Overflow

PowerShell - Match multiple string entries in a CSV file

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related