Powershell, csv match a row and column to modify another column

Question

My problem is quite simple, I have a csv file with a format as such:

Client   Status       Goal       Project
A         Done         Done       Waiting
B         Finished     Done       Cancelled
C                      Waiting    Finished
D         Done         Done       Done

Now, my queestion is simple, I want for example, to update a value on the column 'Goal' that matches client 'B'

I know that I can do import-csv and using calculated properties modify a column, but I have no idea how can I modify a specific row on a column that matches another row in another column and that is my question. I want for example to change Waiting to Finished client C, or change cancelled to waiting on client B.

error on my example, not real headers.

Victor J Mytre
– Victor J Mytre

2019-10-30 16:00:15 +00:00
Commented Oct 30, 2019 at 16:00 — Victor J Mytre
– Victor J Mytre, Commented Oct 30, 2019 at 16:00

Theo · Accepted Answer · 2019-10-30 16:06:06Z

1

You could do that something like this:

$csv = Import-Csv 'D:\clientprojects.csv'
($csv | Where-Object {$_.Client -eq 'C'}).Goal = 'Finished'
($csv | Where-Object {$_.Client -eq 'B'}).Project = 'Waiting'

#output on console
$csv

# write to new CSV file
$csv | Export-Csv -Path 'D:\clientprojects-updated.csv' -NoTypeInformation

output on console:

Client Status   Goal     Project 
------ ------   ----     ------- 
A      Done     Done     Waiting 
B      Finished Done     Waiting 
C               Finished Finished
D      Done     Done     Done

answered Oct 30, 2019 at 16:06

Theo

61.9k8 gold badges28 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Powershell, csv match a row and column to modify another column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related