(PowerBuilder) 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.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Csv
integer li_Success

loo_Csv = create oleobject
// Use "Chilkat_9_5_0.Csv" for versions of Chilkat < 10.0.0
li_rc = loo_Csv.ConnectToNewObject("Chilkat.Csv")
if li_rc < 0 then
    destroy loo_Csv
    MessageBox("Error","Connecting to COM object failed")
    return
end if

li_Success = loo_Csv.LoadFile2("qa_data/csv/csv_wit_comma_separators.csv","utf-8")
if li_Success = 0 then
    Write-Debug loo_Csv.LastErrorText
    destroy loo_Csv
    return
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.
loo_Csv.Delimiter = ";"

Write-Debug loo_Csv.SaveToString()


destroy loo_Csv