Visual FoxPro

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 FoxPro

LOCAL lnSuccess
LOCAL loCsv

lnSuccess = 0

loCsv = CreateObject('Chilkat.Csv')

lnSuccess = loCsv.LoadFile2("qa_data/csv/csv_wit_comma_separators.csv","utf-8")
IF (lnSuccess = 0) THEN
    ? loCsv.LastErrorText
    RELEASE loCsv
    CANCEL
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.
loCsv.Delimiter = ";"

? loCsv.SaveToString()

RELEASE loCsv