Xbase++

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. Xbase++

LOCAL nSuccess
LOCAL oCsv
LOCAL oCsv2

nSuccess := 0

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

oCsv := CreateObject("Chilkat.Csv")

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

//  Show row 0, column 0
? oCsv:GetCell(0, 0)
//  Show row 0, column 1
? oCsv:GetCell(0, 1)
//  Show row 0, column 2
? oCsv:GetCell(0, 2)

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

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

oCsv2 := CreateObject("Chilkat.Csv")
oCsv2:EnableQuotes := 0

nSuccess := oCsv2:LoadFile("qa_data/csv/enableQuotes.csv")

? oCsv2:GetCell(0, 0)
? oCsv2:GetCell(0, 1)
? oCsv2:GetCell(0, 2)
? oCsv2:GetCell(0, 3)

//  Output is:

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

oCsv:destroy()
oCsv2:destroy()