On Tue, Feb 10, 2015 at 5:52 AM, Skip Montanaro <skip.montan...@gmail.com> wrote: > > This snapshot was taken against a running LibreOffice instance here at work > (on Linux). It would appear the fancy schmancy apostrophe was hosed up before > the data ever got to me. Had a guy here with Windows pop up the original file > I got in an actual Excel instance. Same bogosity. >
Just what you always want to see, messy data! > Knowing that, I don't feel the least bit timid about just editing the darn > CSV file to correct the encode/decode/encode error before loading the data > into SQLite. I was worried that since I was doing some Python 3.x stuff > involving Unicode for the first time that I'd screwed something up. > Py3 makes things so easy that the chances are you got it right :) As long as the encoding parameter on the open() call matches the file's actual encoding, chances are you're fine - everything else is done with Unicode characters. ChrisA -- https://mail.python.org/mailman/listinfo/python-list