(VBScript) CSV - Convert Comma to Semicolon Separators

See more CSV Examples

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

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Csv")
set csv = CreateObject("Chilkat.Csv")

success = csv.LoadFile2("qa_data/csv/csv_wit_comma_separators.csv","utf-8")
If (success = 0) Then
    outFile.WriteLine(csv.LastErrorText)
    WScript.Quit
End If

' 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 = ";"

outFile.WriteLine(csv.SaveToString())

outFile.Close