replace delimiter in CSV files

replace.ps1

# with parsing of csv

$inputfile = "Datentabelle 3.txt"
$outputfile = "export.csv"
$inputdelim = "`t"
$outputdelim = ','
$inputenc = "UTF8"
$outputenc = "UTF8" 

rm $outputfile

Measure-Command {
  Get-Content $inputfile -ReadCount 1000 -Encoding $inputenc | ConvertFrom-Csv -Delimiter $inputdelim | ConvertTo-Csv -NoTypeInformation -Delimiter "," | foreach { $_ -replace '^"','' -replace "`",`"",',' -replace '"$','' } | Set-Content -Path $outputfile -Encoding $outputenc
}

# plain replacement of chars without csv parsing

$inputfile = "Datentabelle 4.txt"
$outputfile = "export.csv"
$inputdelim = "`t"
$outputdelim = ','
$inputenc = "UTF8"
$outputenc = "UTF8" 

rm $outputfile


Measure-Command {
  Get-Content $inputfile -ReadCount 1000 -Encoding $inputenc | % { $_ -replace '^"','' -replace """`t""","," -replace '"$','' } | Set-Content -Path $outputfile -Encoding $outputenc
}