(CkPython) CSV Enable Quotes

Explains the EnableQuotes property for the CSV class.

Chilkat Python Downloads install with pip pip3 install chilkat or download... Python Module for Windows, MacOS, Linux, Alpine Linux, Solaris

import chilkat

# 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