B4X

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. B4X

Dim success As Boolean = False

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

Dim csv As ChilkatCsv
csv.Initialize

'  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
Log(csv.GetCell(0, 0))
'  Show row 0, column 1
Log(csv.GetCell(0, 1))
'  Show row 0, column 2
Log(csv.GetCell(0, 2))

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

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

Dim csv2 As ChilkatCsv
csv2.Initialize
csv2.EnableQuotes = False

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

Log(csv2.GetCell(0, 0))
Log(csv2.GetCell(0, 1))
Log(csv2.GetCell(0, 2))
Log(csv2.GetCell(0, 3))

'  Output is:

'   test
'   "123
'   abc"
'   xyz