Replace One CSV Field With Another Through PowerShell

Question

In PowerShell I'm importing a CSV SAMTemp2 which will have a field called SO. Sometimes SO will be populated with "NW" and in these cases I just want to pull the field called ProdProj from the same line and replace the data in SO with the data in ProdProj then export it the data in that condition.

$RepNW = Import-Csv $SAMTemp2
foreach($d in $data){
If($d.SO -eq "NW"){($d.SO).Replace($d.ProdProj)}}
$RepNW | Export-Csv $SAMTemp -NoTypeInformation

I don't get an error, but this doesn't seem to do anything, either. Can anyone assist me, please?

Update

Per Matt below, I tried:

$RepNW = Import-Csv $SAMTemp2
foreach($d in $RepNW){
If($d.SO -eq "NW"){$d.SO = ($d.SO).Replace($d.ProdProj)}}
$RepNW | Export-Csv $SAMTemp -NoTypeInformation

But I'm not seeing any change. Any assistance is appreciated.

You are not writing the changes back. $d.SO = ($d.SO).Replace($d.ProdProj) should do it. Other improvement might help as well. — Matt
– Matt, Commented Mar 22, 2017 at 20:02
@Matt where do I put that? I tried If($d.SO -eq "NW"){$d.SO = ($d.SO).Replace($d.ProdProj)}} but the fields still report as "NW". — Nate
– Nate, Commented Mar 22, 2017 at 21:00
Your replace is flawed maybe. Are you just chenging the value completely ? Why are you using replace — Matt
– Matt, Commented Mar 22, 2017 at 21:10

BenH · Accepted Answer · 2017-03-22 21:11:42Z

3

As LotPings pointed out in this line foreach($d in $data){, you haven't defined $data and it seems that you mean it to be foreach($d in $RepNW){

Secondly, rather than using Replace() you can just set one property to be equal to the other.

Last, this probably easiest to do all in the pipeline with ForEach-Object

Import-Csv $SAMTemp2 | ForEach-Object {
    If($_.SO -eq "NW"){
        $_.SO = $_.ProdProj
    }
    $_
} | Export-Csv $SAMTemp -NoTypeInformation

answered Mar 22, 2017 at 21:11

BenH

10.1k1 gold badge26 silver badges38 bronze badges

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

1 Comment

Nate Over a year ago

Thanks all! This was the answer. And @Matt you're right about my flawed replace. I have a lot of flaws, and not just in scripting.

Collectives™ on Stack Overflow

Replace One CSV Field With Another Through PowerShell

Update

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Update

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related