VBScript

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.

VBScript

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

success = 0

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