Chilkat2-Python

CSV Enable Quotes

Explains the EnableQuotes property for the CSV class. Chilkat2-Python

import chilkat2

success = False

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

csv = chilkat2.Csv()

# EnableQuotes is True by default, but we'll explicitly set to True here:
csv.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 = chilkat2.Csv()
csv2.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