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