AutoIt

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.

AutoIt

Local $bSuccess = False

$oCsv = ObjCreate("Chilkat.Csv")

$bSuccess = $oCsv.LoadFile2("qa_data/csv/csv_wit_comma_separators.csv","utf-8")
If ($bSuccess = False) Then
    ConsoleWrite($oCsv.LastErrorText & @CRLF)
    Exit
EndIf

; 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.
$oCsv.Delimiter = ";"

ConsoleWrite($oCsv.SaveToString() & @CRLF)