title: Issues merging multiple CSV files in Powershell
body: <p>I found a nifty command here - <a href="http://www.stackoverflow.com/questions/27892957/merging-multiple-csv-files-into-one-using-powershell">http://www.stackoverflow.com/questions/27892957/merging-multiple-csv-files-into-one-using-powershell</a> that I am using to merge CSV files -</p>
  <pre><code>Get-ChildItem -Filter *.csv | Select-Object -ExpandProperty FullName | Import-Csv | Export-Csv .\merged\merged.csv -NoTypeInformation -Append
  </code></pre>
  <p>Now this does what it says on the tin and works great for the most part. I have 2 issues with it however, and I am wondering if there is a way they can be overcome:</p>
  <p>Firstly, the merged csv file has CRLF line endings, and I am wondering how I can make the line endings just LF, as the file is being generated?</p>
  <p>Also, it looks like there are some shenanigans with quote marks being added/moved around. As an example:</p>
  <p>Sample row from initial CSV:</p>
  <pre><code>&quot;2021-10-05&quot;|&quot;00:00&quot;|&quot;1212&quot;|&quot;160477&quot;|&quot;1.00&quot;|&quot;3.49&quot;LF
  </code></pre>
  <p>Same row in the merged CSV:</p>
  <pre><code>&quot;2021-10-05|&quot;&quot;00:00&quot;&quot;|&quot;&quot;1212&quot;&quot;|&quot;&quot;160477&quot;&quot;|&quot;&quot;1.00&quot;&quot;|&quot;&quot;3.49&quot;&quot;&quot;CRLF
  </code></pre>
  <p>So see that the first row has lost its trailing quotes, other fields have doubled quotes, and the end of the row has an additional quote. I'm not quite sure what is going on here, so any help would be much appreciated!</p>