Right concatenate a column in a csv file using powershell

Question

Lets say I have a csv with the following columns:

  A        B
   2     1000
  10     1000
 199     1000
9101     1000

I am looking to have column A right fill column B to have a result like the following:

How can I achieve this output?

Thanks!

Mathias R. Jessen · Accepted Answer · 2020-11-04 21:19:47Z

3

You could use Select-Object with a calculated property to "merge" the two into one:

# Import existing data
$data = Import-Csv path\to\data.csv 

# Create a new property B with the value of the existing A + B
$data = $data |Select @{Name = 'B'; Expression = { [int]$_.A + $_.B }}

# Export to a new CSV file
$data | Export-Csv path\to\new.csv

answered Nov 4, 2020 at 21:19

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Collectives™ on Stack Overflow

Right concatenate a column in a csv file using 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