Re: [sqlite] Tedious CSV import question

2009-09-27 Thread C. Mundi
@Nuno: hey that is really nice. Thank you! On 9/27/09, Nuno Lucas wrote: > C. Mundi wrote: >> I'm hoping someone will (please) tell me I missed something in the sqlite >> docs. Otherwise, I guess I'll be using python's csv module to turn my CSV >> file

Re: [sqlite] Tedious CSV import question

2009-09-25 Thread C. Mundi
Cool. Where do I send my application (for citizenship)? :) Carlos On 9/25/09, Petite Abeille wrote: > > On Sep 25, 2009, at 9:21 PM, C. Mundi wrote: > >> Your post neatly articulates virtually every facet of this issue. >> Thank you. I wish we could get everyone to stop

Re: [sqlite] Tedious CSV import question

2009-09-25 Thread C. Mundi
Jay... Your post neatly articulates virtually every facet of this issue. Thank you. I wish we could get everyone to stop using csv. I hate to look at xml but I often wish everyone would use it instead of csv. I would hate to see any of the sqlite core devs waste time on csv. Carlos On 9/25/

Re: [sqlite] Tedious CSV import question

2009-09-24 Thread C. Mundi
On Thu, Sep 24, 2009 at 7:16 PM, wrote: > On Thu, 24 Sep 2009, Rich Shepard wrote: > > > On Thu, 24 Sep 2009, C. Mundi wrote: > > > >> I just bit the bullet and did it. Python has an excellent csv module, > >> capable of handling just about any dialect you&

Re: [sqlite] Tedious CSV import question

2009-09-24 Thread C. Mundi
On Thu, Sep 24, 2009 at 6:45 PM, Rich Shepard wrote: > On Thu, 24 Sep 2009, C. Mundi wrote: > > > I just bit the bullet and did it. Python has an excellent csv module, > > capable of handling just about any dialect you're likely to encounter. I > > am so grate

Re: [sqlite] Tedious CSV import question

2009-09-24 Thread C. Mundi
On Thu, Sep 24, 2009 at 12:37 PM, C. Mundi wrote: > > Hi. I have scanned the list archives and Googled. I may have missed > something, but what I found was not sufficiently general or robust for my > needs. > > Happily, sqlite has a very nice .output mode for CSV. It correct

[sqlite] Tedious CSV import question

2009-09-24 Thread C. Mundi
Hi. I have scanned the list archives and Googled. I may have missed something, but what I found was not sufficiently general or robust for my needs. Happily, sqlite has a very nice .output mode for CSV. It correctly double-quotes fields when they contain a space or a comma, and it correctly 'es