PowerShell Array Filter

Question

I have an array piped into PowerShell. Trying to select what matches today through the next 3 weeks.

1/4/2023    First Last
1/11/2023   First Last
1/19/2023   First Last
1/25/2023   First Last
2/1/2023    First Last
2/8/2023    First Last
2/15/2023   First Last
2/22/2023   First Last
3/1/2023    First Last
3/8/2023    First Last

Expected results would be:

1/19/2023   First Last
1/25/2023   First Last
2/1/2023    First Last
2/8/2023    First Last

Was trying to modify this to get results, but not getting what I need.

$referenceDate = (Get-Date).AddDays(21)
Get-Content -Path 'Dates.ini' |
Where-Object { $_ -match '^(\d{2}/\d{2}/\d{4})' } |
Where-Object { [datetime]::ParseExact($matches[1], 'MM/dd/yyyy', $null) -gt $referenceTime } |
ForEach-Object {
    $_
    #DO SOMETHING.. For demo just output the line(s) that matched
}

My PowerShell kung foo is not strong, and would be very grateful for the answer...

Listed in details. PowerShell version is default for Server 2019.

Santiago Squarzon · Accepted Answer · 2023-01-20 00:35:04Z

4

I would definitely consider using a switch here with the -Regex flag:

$referenceDate = (Get-Date).AddDays(21)

switch -Regex -File Dates.ini {
    '^(?:\d{1,2}/){2}\d{4}' {
        $date = Get-Date $Matches[0]
        if($date -ge [datetime]::Today -and $date -le $referenceDate) {
            $_
        }
    }
}

Regarding your code, it's almost correct, there are 3 problems:

The regex needs a bit tweaking.
The call to ParseExact is not using the correct Date Format.
You're currently filtering for dates greater than 3 weeks, instead what you want is lower than or equal to 3 weeks and greater than or equal to Today.

$referenceDate = (Get-Date).AddDays(21)

Get-Content -Path 'Dates.ini' |
    Where-Object { $_ -match '^(\d{1,2}/\d{1,2}/\d{4})' } |
    Where-Object {
        $date = [datetime]::ParseExact($Matches[1], 'M/d/yyyy', $null)
        $date -ge [datetime]::Today -and $date -le $referenceDate
    } | ForEach-Object { $_ }

edited Jan 20, 2023 at 0:35

answered Jan 19, 2023 at 23:57

Santiago Squarzon

65.5k5 gold badges26 silver badges59 bronze badges

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

3 Comments

slacker220 Over a year ago

Thank you very much! Going to give this a try today :). I will report back in a few hours.

slacker220 Over a year ago

Thank you so very much! This helped me get to my end goal. Greatly appreciated!

Santiago Squarzon Over a year ago

@slacker220 my pleasure, just saw the previous comment :P thanks for accepting the answer

Collectives™ on Stack Overflow

PowerShell Array Filter

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