Using Where method with ForEach Loop

Question

Just curious if it is possible to use the Where Method in combination with the ForEach loop?

$numbers = @(1..10)

ForEach($number in $numbers.Where({$number = 2})){

    Write-Host "the number is $number"

}

Ok figured it out

Turns out you can also perform this with Get-ChildItem using the following

$start = Get-Date
$end = (Get-Date).AddDays(-1)
$sourcePath = Get-ChildItem -path "C:\"

ForEach($file in ($sourcePath.where({$_.CreationTime -ge $end -and 
$_.CreationTime -le $start}))){

    Write-Host $file.Name

}

Thanks!

-eq not =, $_ not $number $numbers = 1..10; ForEach($number in $numbers.Where{$_ -eq 2}) — js2010
– js2010, Commented Dec 11, 2020 at 20:34
Is there any reason not to use pipes? Get-ChildItem -Path "C:\" | Where-Object { $_.CreationTime -ge $end -and $_.CreationTime -le $start } | ForEach-Object { Write-Host $_.Name } — Dabombber
– Dabombber, Commented Dec 11, 2020 at 22:35
You can get slightly better performance by avoiding the pipeline. Probably immaterial in this case. — OwlsSleeping
– OwlsSleeping, Commented Dec 12, 2020 at 10:48
@Dabombber the reason that I can’t use the pipe is because the actual code that this goes in is in a nested loop where I need to use BREAK to get out of that inner loop. However, when using break with pipes, apparently it stops the entire pipe which is why I have to use ForEach so that the outer loop will continue. I was just providing a super super basic example so I could grasp the syntax for the concept to apply to my actual code. — N.Ha
– N.Ha, Commented Dec 12, 2020 at 13:03
@N.Ha Yea, that's an annoying way to get caught out. It may make your code more readable if you combine the Where-Object with Get-ChildItem rather than put it in the loop. $fileList = Get-ChildItem -Path "C:\" | Where-Object {$_.CreationTime -ge $end -and $_.CreationTime -le $start} and foreach ($file in $fileList) {. Or go the other way and use plain ifs: foreach ($file in $sourcePath) { if ($file.CreationTime -ge $end -and $file.CreationTime -le $start) { Write-Host $file.Name } }. Just use whichever seems more appropriate. — Dabombber
– Dabombber, Commented Dec 13, 2020 at 2:40

OwlsSleeping · Accepted Answer · 2020-12-11 18:03:41Z

1

It's possible, you do get a nasty level of nesting compared with doing it on the same line as $numbers though.

$numbers = @(1..10)

ForEach($number in ($numbers.Where({$_ -eq 2}))){

    Write-Host "the number is $number"

}

answered Dec 11, 2020 at 18:03

OwlsSleeping

1,5902 gold badges12 silver badges21 bronze badges

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

3 Comments

N.Ha Over a year ago

so follow up question. Will the Where method work if trying to use it with the Get-ChildItem? For instance

$path = "C:\"      ForEach($file in $path.Where($_.CreationTime -ge $end -and $_.CreationTime -le $start){        Write-Host "something"     }

OwlsSleeping Over a year ago

Yes you can use the .Where method on the results of Get-Childitem, or any other array. It makes no sense to use it on a string like "C:\" in your example.

N.Ha Over a year ago

Kind of a weird situation I was in but I was able to figure out the syntax. Thank you so much! Edited original question :D

Collectives™ on Stack Overflow

Using Where method with ForEach Loop

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related