Visual FoxPro

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. Visual FoxPro

LOCAL lnSuccess
LOCAL loCsv
LOCAL loCsv2

lnSuccess = 0

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

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:

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