Lua

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. Lua

local chilkat = require("chilkat")

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

local csv = chilkat.Csv.new()

-- EnableQuotes is true by default, but we'll explicitly set to true here:
csv.enable_quotes = true
local success = csv:load_file("qa_data/csv/enableQuotes.csv")

-- Show row 0, column 0
print(csv:get_cell(0, 0))
-- Show row 0, column 1
print(csv:get_cell(0, 1))
-- Show row 0, column 2
print(csv:get_cell(0, 2))

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

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

local csv2 = chilkat.Csv.new()
csv2.enable_quotes = false

success = csv2:load_file("qa_data/csv/enableQuotes.csv")

print(csv2:get_cell(0, 0))
print(csv2:get_cell(0, 1))
print(csv2:get_cell(0, 2))
print(csv2:get_cell(0, 3))

-- Output is:

--  test
--  "123
--  abc"
--  xyz