Input file:

column1;column2;column3
data1a;data2a;data3a
data1b;data2b;data3b

Goal: An output file with reordered columns like this:

column1;column3;column2
...

Question: What is a good way of using powershell to solve this problem?

I am aware of the existence of CSV related cmdlets, but these have limitations. Note that the order of records does not need to be changed, so loading the entire input/output file in memory should not be needed.

powershell csv
Edit
Report