(AutoIt) CSV Enable Quotes
Explains the EnableQuotes property for the CSV class.
; 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
Local $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
|