(Excel) CSV Enable Quotes

Explains the EnableQuotes property for the CSV class.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim csv As Chilkat.Csv
Set csv = Chilkat.NewCsv

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

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

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

Dim csv2 As Chilkat.Csv
Set csv2 = Chilkat.NewCsv
csv2.EnableQuotes = False

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

Debug.Print csv2.GetCell(0,0)
Debug.Print csv2.GetCell(0,1)
Debug.Print csv2.GetCell(0,2)
Debug.Print csv2.GetCell(0,3)

' Output is:

'  test
'  "123
'  abc"
'  xyz