Add Column to CSV Windows PowerShell

by

Here’s one way to do that using Calculated Properties:

Import-Csv file.csv | 
Select-Object *,@{Name="column3";Expression={'setvalue'}} | 
Export-Csv file.csv -NoTypeInformation

You can find more on calculated properties here: http://technet.microsoft.com/en-us/library/ff730948.aspx.

In a nutshell, you import the file, pipe the content to the Select-Object cmdlet, select all exiting properties (e.g ‘*’) then add a new one.

More Related Contents:

  1. how do I loop through a line from a csv file in powershell
  2. How to remove all quotations mark in the csv file using powershell script?
  3. Merging multiple CSV files into one using PowerShell
  4. ConvertTo-Csv Output without quotes
  5. How to use powershell to reorder CSV columns?
  6. Using Powershell environmental variables as strings when outputting files
  7. Read a Csv file with powershell and capture corresponding data
  8. Remove last line from file with Powershell
  9. PS Script is exporting an empty CSVs
  10. Renaming files by reformatting existing filenames – placeholders in replacement strings used with the -replace operator
  11. Unable to Pause or Sleep after Select-Object
  12. What’s the better (cleaner) way to ignore output in PowerShell? [closed]
  13. Is there a way to create an alias to a cmdlet in a way that it only runs if arguments are passed to the alias?
  14. Using Get-ChildItem -Exclude or -Include returns nothing
  15. ‘kubectl patch’ works on Linux Bash but not in Windows Powershell ISE
  16. Ternary operator in PowerShell
  17. Export hashtable to CSV with the key as the column heading
  18. CMD pipe different form Powershell pipe?
  19. What’s the difference between single quote and double quote to define a string in powershell
  20. Convert Unix time with PowerShell
  21. How can I get the file system location of a PowerShell script?
  22. If Statement Against Dynamic Variable [duplicate]
  23. You cannot call a method on a null-valued expression
  24. How do I call the PowerShell CLI robustly, with respect to character encoding, input and output streams, quoting and escaping?
  25. In what conditions does powershell unroll items in the pipeline?
  26. How to execute a PowerShell function several times in parallel?
  27. How to send CTRL or ALT + any other key?
  28. notcontains not working for User objects pulled from AD Groups
  29. PowerShell launch script in new instance
  30. How to return specific data type from PowerShell function i.e. DataTable

Leave a Comment