Powershell csv delete row

Question

I'm trying to delete rows from csv base off certain conditions in two columns. Status column if it has T and the second column is Term Date if the date is older then the past 5 days.

little info column STATUS has either "A" or "T".

$path = "data.csv"
$maxAge = (Get-Date).AddDays(-5).Date
Import-Csv $path | Where-Object {$_.STATUS -eq "A" -or $_.TERMDATE -gt $maxAge} | 
Export-Csv -Path temp.csv -NoTypeInformation

it works to a certain degree, but still shows dates from last year.

Use [datetime]$_.TERMDATE -gt $maxAge in your condition. $_.TERMDATE is going to be a string when read from CSV. It is likely not accurate for your comparison. — AdminOfThings
– AdminOfThings, Commented Aug 4, 2020 at 20:15

AdminOfThings · Accepted Answer · 2020-08-04 20:18:34Z

1

You will need to cast the TERMDATE value to a datetime object in order to make an accurate comparison.

$path = "data.csv"
$maxAge = (Get-Date).AddDays(-5).Date
Import-Csv $path |
    Where-Object {$_.STATUS -eq "A" -or [datetime]$_.TERMDATE -gt $maxAge} |
        Export-Csv -Path temp.csv -NoTypeInformation

If the [datetime] cast does not work, then you will need to parse the string and perform a conversion. In order to provide a solution for that, we need to know the original date format of TERMDATE.

answered Aug 4, 2020 at 20:18

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

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

1 Comment

Rick G Over a year ago

worked thank you. how would i go about counting work days only.

Collectives™ on Stack Overflow

Powershell csv delete row

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related