PowerShell

CSV - Convert Comma to Semicolon Separators

See more CSV Examples

Load a CSV using comma delimiters and convert to a CSV using semicolon delimiters.

Note: This example requires Chilkat v9.5.0.89 or greater.

PowerShell

Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll"

$success = $false

$csv = New-Object Chilkat.Csv

$success = $csv.LoadFile2("qa_data/csv/csv_wit_comma_separators.csv","utf-8")
if ($success -eq $false) {
    $($csv.LastErrorText)
    exit
}

# Note: Prior to Chilkat v9.5.0.89, setting the Delimiter property did not modify the already-existing
# rows in the CSV.  Updating the Delimiter property in Chilkat v9.5.0.89 or greater will cause
# all rows to be updated with the new delimiter.
$csv.Delimiter = ";"

$($csv.SaveToString())