PureBasic

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.

PureBasic

IncludeFile "CkCsv.pb"

Procedure ChilkatExample()

    success.i = 0

    csv.i = CkCsv::ckCreate()
    If csv.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    success = CkCsv::ckLoadFile2(csv,"qa_data/csv/csv_wit_comma_separators.csv","utf-8")
    If success = 0
        Debug CkCsv::ckLastErrorText(csv)
        CkCsv::ckDispose(csv)
        ProcedureReturn
    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.
    CkCsv::setCkDelimiter(csv, ";")

    Debug CkCsv::ckSaveToString(csv)


    CkCsv::ckDispose(csv)


    ProcedureReturn
EndProcedure