Ruby

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. Ruby

require 'chilkat'

success = false

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

csv = Chilkat::CkCsv.new()

# EnableQuotes is true by default, but we'll explicitly set to true here:
csv.put_EnableQuotes(true)
success = csv.LoadFile("qa_data/csv/enableQuotes.csv")

# Show row 0, column 0
print csv.getCell(0,0) + "\n";
# Show row 0, column 1
print csv.getCell(0,1) + "\n";
# Show row 0, column 2
print csv.getCell(0,2) + "\n";

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

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

csv2 = Chilkat::CkCsv.new()
csv2.put_EnableQuotes(false)

success = csv2.LoadFile("qa_data/csv/enableQuotes.csv")

print csv2.getCell(0,0) + "\n";
print csv2.getCell(0,1) + "\n";
print csv2.getCell(0,2) + "\n";
print csv2.getCell(0,3) + "\n";

# Output is:

#  test
#  "123
#  abc"
#  xyz