read csv error question

Vincent Davis vincent at vincentdavis.net
Tue Feb 24 00:18:00 CET 2009


I am trying to read a csv file from excel on a mac. I get the following
error.SystemExit: file some.csv, line 1: new-line character seen in unquoted
field - do you need to open the file in universal-newline mode?
I was using the example code
import csv, sys

reader = csv.reader(open('/Volumes/vincentdavis
2/match/data/matchdata2008.csv', "rb"))
try:
    for row in reader:
        print row
except csv.Error, e:
    sys.exit('file %s, line %d: %s' % (filename, reader.line_num, e))

I think this has to do with the end of line character but I am unsure how to
fix it. I don't what to change the actual csv file I would like to fix the
code.

Thanks
Vincent Davis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20090223/da2f0153/attachment.html>


More information about the Python-list mailing list