How to use powershell to reorder CSV columns?

by

Here is the solution suitable for millions of records (assuming that your data do not have embedded ‘;’)

$reader = [System.IO.File]::OpenText('data1.csv')
$writer = New-Object System.IO.StreamWriter 'data2.csv'
for(;;) {
    $line = $reader.ReadLine()
    if ($null -eq $line) {
        break
    }
    $data = $line.Split(";")
    $writer.WriteLine('{0};{1};{2}', $data[0], $data[2], $data[1])
}
$reader.Close()
$writer.Close()

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. Add Column to CSV Windows PowerShell
  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. For PowerShell cmdlets, can I always pass a script block to a string parameter?
  11. VSCode is suddenly defaulting to powershell for integrated terminal and tasks
  12. Upload files with FTP using PowerShell
  13. How do I write to standard error in PowerShell?
  14. Pass arguments to a scriptblock in powershell
  15. Scheduled Task Powershell Script – Runs OK as user account, but not as SYSTEM
  16. Powershell color formatting with format operator
  17. Powershell string variable with UTF-8 encoding
  18. Calling dynamic variable in PowerShell
  19. Passing string in Get-ADUser filter parameter causes error – property not found in pscustomobject
  20. Problems using local variables in a remote commands
  21. How to get the current directory of the cmdlet being executed
  22. How to make an authenticated web request in Powershell?
  23. $string.Substring Index/Length exception
  24. How do I compress files using powershell that are over 2 GB?
  25. How to pass a custom function inside a ForEach-Object -Parallel
  26. PowerShell string interpolation syntax
  27. Exit code from a batch file is not propagated to the parent powershell script
  28. How to uninstall an app that another user installed?
  29. Uploading file to HTTP via Powershell
  30. Strange behavior for PowerShell Length after ForEach method

Leave a Comment