On Thu, Sep 24, 2009 at 9:21 PM, C. Mundi <cmu...@gmail.com> wrote: > On Thu, Sep 24, 2009 at 7:16 PM, <cmar...@unc.edu> 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 likely to encounter. >> I >> >> am so grateful I did not have to write a parser for CSV. In just a few >> >> lines I can read the csv right into sqlite. If anyone wants the code I >> >> will post it here if deemed appropriate.
and, since there is more than one way to do it, an alternative http://search.cpan.org/~makamaka/Text-CSV-1.13/lib/Text/CSV.pm >> >> Please send me a copy. >> >> Chris >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> Christopher F. Martin >> School of Medicine >> Center for Digestive Diseases & Nutrition >> CB# 7555, 4104 Bioinformatics Bldg. >> University of North Carolina at Chapel Hill >> Chapel Hill, North Carolina 27599-7555 >> Phone: 919.966.9340 Fax: 919.966.7592 >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > Here you go, Chris. Please note the disclaimer, which is as serious if > somewhat overwrought. I cannot offer support for this script, but I suspect > you'll have no problem grokking it and improvements are always appreciated. > Good luck! > > Carlos > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users