CkPython

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. CkPython

import chilkat

success = False

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

csv = chilkat.CkCsv()

# 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))
# Show row 0, column 1
print(csv.getCell(0,1))
# Show row 0, column 2
print(csv.getCell(0,2))

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

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

csv2 = chilkat.CkCsv()
csv2.put_EnableQuotes(False)

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

print(csv2.getCell(0,0))
print(csv2.getCell(0,1))
print(csv2.getCell(0,2))
print(csv2.getCell(0,3))

# Output is:

#  test
#  "123
#  abc"
#  xyz