Using Powershell "where" command to compare against Array of values

Question

I'm trying to figure out a way to get this command to filter from an array of values as opposed to one value. Currently this is how my code is (and it works when $ExcludeVerA is one value):

$ExcludeVerA = "7"

$java = Get-WmiObject -Class win32_product | where { $_.Name -like "*Java*"} |
where ({ $_.Version -notlike "$ExcludeVerA*" })

And I'd like $ExcludeVerA to have an array of values like so (this currently doesn't work):

$ExcludeVerA = "7", "3", "4"

foreach ($x in $ExcludeVerA)
{

$java = Get-WmiObject -Class win32_product | where { $_.Name -like "*Java*"} |
where ({ $_.Version -notlike "$ExcludeVerA*" })

}

Any ideas of why this second block of code doesn't work or other ideas of what I can do?

stej · Accepted Answer · 2013-05-07 13:35:35Z

17

Try -notcontains

where ({ $ExcludeVerA -notcontains $_.Version })

so if I understand it corretly, then

$ExcludeVerA = "7", "3", "4"

$java = Get-WmiObject -Class win32_product | where { $_.Name -like "*Java*"} |
where ({ $ExcludeVerA -notcontains $_.Version })

That was direct answer to your question. Possible solution might be something like this:

$ExcludeVerA = "^(7|3|4)\."
$java = Get-WmiObject -Class win32_product | 
          where { $_.Name -like "*Java*"} |
          where { $_.Version -notmatch $ExcludeVerA}

it uses regex to get job done.

edited May 7, 2013 at 13:35

answered May 7, 2013 at 13:27

stej

29.6k11 gold badges76 silver badges106 bronze badges

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

2 Comments

ThreePhase Over a year ago

The first way doesn't work because the $_.version properties of these objects is typically a long number like: 7.01.04756 and I need to filter by only the first number (i.e. I need to search 7*).

ThreePhase Over a year ago

However, the second way you posted using regular expressions works beautifully! And it's simple and elegant. It's also introduced me to regular expressions, so thanks for that :)

Shay Levy · Accepted Answer · 2013-05-07 13:37:25Z

3

Try this:

Get-WmiObject -Class Win32_Product -Filter "Name LIKE '%Java%'" | 
Where-Object {$_.Version -notmatch '[734]'}

answered May 7, 2013 at 13:37

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

1 Comment

ThreePhase Over a year ago

Thing is, I need it to notmatch 7*, not just 7, as the version numbers tend to be long (but the stuff after the 7 doesn't matter. Using regular expressions as suggested in Stej's answer did the trick. Thanks, though.

Collectives™ on Stack Overflow

Using Powershell "where" command to compare against Array of values

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related