Visual Basic 6.0

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.

Visual Basic 6.0

Dim success As Long
success = 0

Dim csv As New ChilkatCsv

success = csv.LoadFile2("qa_data/csv/csv_wit_comma_separators.csv","utf-8")
If (success = 0) Then
    Debug.Print csv.LastErrorText
    Exit Sub
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 = ";"

Debug.Print csv.SaveToString()