AutoIt

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. AutoIt

Local $bSuccess = False

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

$oCsv = ObjCreate("Chilkat.Csv")

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

;  Show row 0, column 0
ConsoleWrite($oCsv.GetCell(0,0) & @CRLF)
;  Show row 0, column 1
ConsoleWrite($oCsv.GetCell(0,1) & @CRLF)
;  Show row 0, column 2
ConsoleWrite($oCsv.GetCell(0,2) & @CRLF)

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

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

$oCsv2 = ObjCreate("Chilkat.Csv")
$oCsv2.EnableQuotes = False

$bSuccess = $oCsv2.LoadFile("qa_data/csv/enableQuotes.csv")

ConsoleWrite($oCsv2.GetCell(0,0) & @CRLF)
ConsoleWrite($oCsv2.GetCell(0,1) & @CRLF)
ConsoleWrite($oCsv2.GetCell(0,2) & @CRLF)
ConsoleWrite($oCsv2.GetCell(0,3) & @CRLF)

;  Output is:

;   test
;   "123
;   abc"
;   xyz