title: Importing an CSV and replacing all special characters (Umlauts)
body: <p>I'm trying to import a CSV and want to change all special characters in the CSV. 
  e.g. ö -> oe ; ü -> ue ; etc.
  and than export all of this back to the csv</p>
  
  <p>Content of CSV Example: </p>
  
  <pre><code>101|49|201907020|DE|bla|Schütze|Yayjay|||info|info2||||||||DE||||||||
  101|49|201907020|DE|bla|Götther|Yayway|||info|info2||||||||DE||||||||
  101|49|201907020|DE|bla|blub|Yayway|||info|info2||||||||DE||||||||
  </code></pre>
  
  <p>Tried different ways.</p>
  
  <ol>
  <li><p>using the "-replace" command</p>
  
  <p>$line = $line -replace 'ü', 'ue'</p></li>
  <li><p>using the ".replace" command</p>
  
  <p>$line = $line.Replace('ö','oe').Replace('ä','ae')</p></li>
  </ol>
  
  <p>-- </p>
  
  <pre><code>$importfile = "Path to CSV.csv"
  $exportfile = "Path to Export.csv"
  $Content = import-csv $importfile -Encoding UTF8 -Header A
  
  $Content | Foreach-Object { 
  
      foreach ($property in $_.PSObject.Properties)
      {
  
          [String]$line = $property.Value
  
          Write-host "Linie 1 $line" 
          $line = $line -replace 'ü', 'ue'
  
  # Commented to see the different outputs
  #$line1 = $line.Replace('ö','oe').Replace('ä','ae').Replace('ü','ue').Replace('ß','ss').Replace('Ö','Oe').Replace('Ü','Ue').Replace('Ä','Ae')
          Write-host "Linie 2 $line" 
      }
  }
  $Content 
  </code></pre>
  
  <p>It is not replacing the special characters. </p>
  
  <p>If I replace the $property.value with a string like "Bla|ü|" the script is replacing ü to ue.</p>