Simplify Powershell Where-Object

Question

I have working Import-Csv statement that uses Where-Object

Import-Csv D:\Script\my.csv | Where-Object {$_.SourceIP -Like '10.251.22.11*' -Or $_.SourceIP -Like '10.251.22.*' -Or $_.DestinationIP -Like '10.251.22.11*' -Or $_.DestinationIP -Like '10.251.22.*'}

If I try to simplify the statement, it doesn't work

Import-Csv D:\Script\my.csv | Where-Object {($_.SourceIP -Like ('10.251.22.11*' -Or '10.251.22.*')) -Or ($_.DestinationIP -like ('10.251.22.11*' -Or '10.251.22.*'))}

Google is not helping :-(

-like accepts only a single string with wildcards. See help about_Operators for details. There is no -or for -like. — Bill_Stewart
– Bill_Stewart, Commented May 11, 2015 at 16:53

Samuel Prout · Accepted Answer · 2015-05-11 19:30:04Z

1

Instead of -like, use -match in this case.

Import-Csv D:\Script\my.csv | Where-Object {$_.SourceIP -match '^10\.251\.22\.*' -or $_.DestinationIP -match '^10\.251\.22\.*'}

Also, 10.251.22.* will match 10.251.22.11*, so you can combine them.

edited May 11, 2015 at 19:30

answered May 11, 2015 at 17:28

Samuel Prout

6655 silver badges16 bronze badges

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

6 Comments

user4003407 Over a year ago

Instead of -like, use -match: I does not think that OP want to match this 123.210.251.225 address by this 10.251.22.* pattern ('123.210.251.225' -match '10.251.22.*' returns true).

Samuel Prout Over a year ago

@PetSerAl Good catch, thanks. Added the '^' character to indicate start of string.

user4003407 Over a year ago

You also need to do something with dots, as them means any char, rather than literal dot, for example you matching to 10.251.225.123. At least you should use literal dot at the end of pattern ^10.251.22\..

Samuel Prout Over a year ago

Presuming those dots are a part of an IP address, she should just escape them. Thanks

user4003407 Over a year ago

You still matching to 10.251.225.123, as you apply * (zero or more) to last dot.

|

Collectives™ on Stack Overflow

Simplify Powershell Where-Object

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related