(PowerBuilder) CSV Enable Quotes

Explains the EnableQuotes property for the CSV class.

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

integer li_rc
oleobject loo_Csv
integer li_Success
oleobject loo_Csv2

// The CSV in this example contains this:   test;"123;abc";xyz

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

// EnableQuotes is 1 by default, but we'll explicitly set to 1 here:
loo_Csv.EnableQuotes = 1
li_Success = loo_Csv.LoadFile("qa_data/csv/enableQuotes.csv")

// Show row 0, column 0
Write-Debug loo_Csv.GetCell(0,0)
// Show row 0, column 1
Write-Debug loo_Csv.GetCell(0,1)
// Show row 0, column 2
Write-Debug loo_Csv.GetCell(0,2)

// Output is: 
//  test
//  123;abc
//  xyz

// -------------------------------------------
// Turn off EnableQuotes and see what happens:

loo_Csv2 = create oleobject
// Use "Chilkat_9_5_0.Csv" for versions of Chilkat < 10.0.0
li_rc = loo_Csv2.ConnectToNewObject("Chilkat.Csv")

loo_Csv2.EnableQuotes = 0

li_Success = loo_Csv2.LoadFile("qa_data/csv/enableQuotes.csv")

Write-Debug loo_Csv2.GetCell(0,0)
Write-Debug loo_Csv2.GetCell(0,1)
Write-Debug loo_Csv2.GetCell(0,2)
Write-Debug loo_Csv2.GetCell(0,3)

// Output is:

//  test
//  "123
//  abc"
//  xyz


destroy loo_Csv
destroy loo_Csv2