[Solved] Filtering and Merging Many Large CSV Files [closed]
[ad_1] From a performance point of view you probably want to avoid Import-Csv/Export-Csv and go with a StreamReader/StreamWriter approach. Something like this: $inputFolder=”C:\some\folder” $outputFile=”C:\path\to\output.csv” $writer = New-Object IO.StreamWriter ($outputFile, $false) Get-ChildItem $inputFolder -File | Where-Object { … # <– filtering criteria for selecting input files go here } | ForEach-Object { $reader = New-Object IO.StreamReader … Read more