Question:
I have a simple batch script that copies multiple csv files into one csv and i can’t seem to find a way to do the same thing in powershell at a comparable speed. In batch it goes like this:
|
1 2 |
Copy "*.csv" Merged.csv |
It copies roughly 20 3MB csv’s to one file in mere seconds.
In powershell the closest i’ve come is:
|
1 2 |
dir *.csv | Import-Csv | Export-Csv allsites.csv -NoTypeInformation |
This method takes a really long time. Is there a method in powershell would be comparable in speed to the DOS command above?
Answer:
This should do the same as you DOS command.
|
1 2 |
(get-content *.csv) | set-content Merged.csv |
But either one are going to end up with extra header rows in the result file.