Re: How best to archive in CSV format
Re: How best to archive in CSV format
- Subject: Re: How best to archive in CSV format
- From: Ronald Oussoren <email@hidden>
- Date: Wed, 18 May 2005 22:49:28 +0200
On 17-mei-2005, at 4:36, Bob Ippolito wrote:
On May 16, 2005, at 10:12 PM, Brian Smith wrote:
On May 17, 2005, at 9:43 AM, Bob Ippolito wrote:
One alternative is to look at PyObjC, because Python ships with a
csv module.. though it's not optimal since current versions have
a limitation such that it only knows how to deal with
bytestrings, not unicode, so you have to encode everything into
utf-8 before putting it into the csv and decode it from utf-8
after getting it out.
I've used python to read a csv file and it can't handle mac line
endings too, which the files I need to read have. So, with
PyObjC, I used NSString's componentsSeparatedByString: method to
read the file, so I have found this to be useful, but obviously
you have to experiment given on csv files you have. I did have to
strip some quote marks from the ends of the array of strings, but
I was able to still do it easily with NSString and NSArray methods.
Fields containing quotes and comma's require additional work. Using
the csv module requires less thought.
Actually it can read Mac line endings (bare '\r') just fine if you
open the file with universal newlines (the 'U' mode). I do this
all the time.
Technically that is not correct, you need to use lineterminator='\r'
in the dialect.
Ronald
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden