Renaming CSV column header and merge results with Powershell

Question

So I'm just starting out with this whole Powershell thing and so far so good - until now. I just can't figure out how to do this! I'm looking at manipulating CSV files which are output from one system (which I can't change at output), renaming some column headers and merging a couple of the results into one column so that it matches the input requirements to upload into another system (again, I can't change those parameters). So, as an example.

The first file is created: File1.csv "A","B","C""1","2","3"

I want a powershell script that will output: File2.csv "X","Y""1","23" So I can import it into another system.

I hope that all makes sense, and thanks in advance for any assistance.

Ansgar Wiechers · Accepted Answer · 2016-04-07 11:34:07Z

1

I'm going to assume that your actual/desired formats of your files look like this:

"A","B","C"
"1","2","3"

"X","Y"
"1","23"

rather than having everything in one line. If that's correct you can import File1.csv with Import-Csv, rename and merge columns with calculated properties:

... | Select-Object @{n='X';e={$_.A}}, @{n='Y';e={$_.B + $_.C}} | ...

and write the result to File2.csv with Export-Csv.

answered Apr 7, 2016 at 11:34

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

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

Collectives™ on Stack Overflow

Renaming CSV column header and merge results with Powershell

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