title: Add header to multiple CSV files
body: <p>I'm looking for a way to add a header line into multiple CSV files.
  Problem with this code below is that it will add an extra empty row at the end of each file. I don't understand why there is extra empty line but I need to delete those lines.</p>
  
  <pre class="lang-psh prettyprint-override"><code>$header="Column1,Column2,Column3,Column4,Column5,Column6"
  Get-ChildItem .\ -Recurse -Filter *.csv| Foreach-Object {
    $header+"`r`n"+ (Get-Content $_.FullName | Out-String) |
      Set-Content -Path $_.FullName
  }
  </code></pre>