title: Change delimiter in a csv from ; to ,
body: <p>I cannot seem to change the delimiter in a .csv from <code>;</code> to <code>,</code>.</p>
  
  <p>The issue is that one of our overseas customers have a default delimiter of <code>;</code> because of regional settings, but our system requires the <code>,</code> separator.</p>
  
  <p>I cannot use the <code>-replace</code> because there are semicolons in some string entries that need to be kept there.</p>
  
  <p>Here are the options I have tried:</p>
  
  <pre><code>Import-Csv -path $home\ | Export-Csv C:\Users\Dean\Desktop\test.csv -useculture
  
  Import-Csv -path $home | Export-Csv C:\Users\Dean\Desktop\test\test.csv -Delimiter ","
  
  Import-Csv -path $home | Export-Csv C:\Users\Dean\Desktop\test.csv -Replace "^\"|\"$", ""
  </code></pre>
  
  <p>I have also tried</p>
  
  <pre><code>Import-Csv -UseCulture | ConvertTo-Csv | Out-File and Import-Csv -Delimiter | ConvertTo-Csv | Out-File
  </code></pre>
  
  <p>None of these options are throwing out errors but the delimiter is still <code>;</code> when checking the csv again. The only time I have seen these args work are if I export or outfile a csv to a location without the <code>-delimiter</code> or <code>-useculture</code> arg.</p>