Lianja

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.

Lianja

llSuccess = .F.

loCsv = createobject("CkCsv")

llSuccess = loCsv.LoadFile2("qa_data/csv/csv_wit_comma_separators.csv","utf-8")
if (llSuccess = .F.) then
    ? loCsv.LastErrorText
    release loCsv
    return
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