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.

PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Csv

li_Success = 0

loo_Csv = create oleobject
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