Powershell to read CSV header with space

Question

I have a powershell script to parse a CSV file and add a new value to specific header. For Example Input file is a header and i want to replace the value under it. I have added the logic and it works for normal hearder but as this header has a space i am not able to manage it. Can you please help me how can i manage the space

Convert into CSV

Import-CSV $CSV_File | ForEach-Object {
{$_.Input file} = "$machine_path\file"
{$_.Output file} ="$machine_path\Output"
$_ |  Export-Csv $machine_path\new.csv -NoTypeInformation
}

Mathias R. Jessen · Accepted Answer · 2016-05-24 08:29:45Z

1

If you want to dereference a property with spaces in the name, use quotation marks:

Import-CSV $CSV_File | ForEach-Object {
  $_.'Input file' = "$machine_path\file"
  $_.'Output file' = "$machine_path\Output"
  $_ 
}| Export-Csv $machine_path\new.csv -NoTypeInformation

answered May 24, 2016 at 8:29

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

Powershell to read CSV header with space

Convert into CSV

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

Convert into CSV

1 Answer 1

Comments

Related