Xojo Plugin

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. Xojo Plugin

Dim success As Boolean
success = False

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

Dim csv As New Chilkat.Csv

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

// Show row 0, column 0
System.DebugLog(csv.GetCell(0,0))
// Show row 0, column 1
System.DebugLog(csv.GetCell(0,1))
// Show row 0, column 2
System.DebugLog(csv.GetCell(0,2))

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

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

Dim csv2 As New Chilkat.Csv
csv2.EnableQuotes = False

success = csv2.LoadFile("qa_data/csv/enableQuotes.csv")

System.DebugLog(csv2.GetCell(0,0))
System.DebugLog(csv2.GetCell(0,1))
System.DebugLog(csv2.GetCell(0,2))
System.DebugLog(csv2.GetCell(0,3))

// Output is:

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