(Visual FoxPro) CSV Enable Quotes

Explains the EnableQuotes property for the CSV class.

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

LOCAL loCsv
LOCAL lnSuccess
LOCAL loCsv2

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Csv')
loCsv = CreateObject('Chilkat.Csv')

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

* Show row 0, column 0
? loCsv.GetCell(0,0)
* Show row 0, column 1
? loCsv.GetCell(0,1)
* Show row 0, column 2
? loCsv.GetCell(0,2)

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

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Csv')
loCsv2 = CreateObject('Chilkat.Csv')
loCsv2.EnableQuotes = 0

lnSuccess = loCsv2.LoadFile("qa_data/csv/enableQuotes.csv")

? loCsv2.GetCell(0,0)
? loCsv2.GetCell(0,1)
? loCsv2.GetCell(0,2)
? loCsv2.GetCell(0,3)

* Output is:

*  test
*  "123
*  abc"
*  xyz

RELEASE loCsv
RELEASE loCsv2