Many thanks Andrew for this excellent piece of knowledge :-). 4 characters of code and everything is great!
Regards, David On Friday, October 14, 2005, at 12:11 AM, Andrew McNamara wrote: >> Hi. I have had good success with CSV module but recently came across >> problem with reading excel from Mac Office. The trouble is with line >> endings. Instead of \r\n you have just \r and the file as a whole >> appears as a single line. CSV coughs and provides this exception: >> >> _csv.Error: newline inside string >> >> Saving as Windows (text) in Mac Office solves this but I don't >> necessarily want to force users to save this way just to avoid >> modifying my code. There is a lineterminator in the package. Adding >> parameter lineterminator='\r' did not correct the problem. > > Open the file in universal-newline mode - for example: > > sample = open(filename, 'rU') > > "lineterminator" is only used for output - we use the supplied iterator > (and whatever conventions it imposes) for input. > > -- > Andrew McNamara, Senior Developer, Object Craft > http://www.object-craft.com.au/ > -- http://mail.python.org/mailman/listinfo/python-list
