* separated values

Cliff Wells logiplexsoftware at earthlink.net
Tue Jan 15 14:23:30 EST 2002


> I'm a bit biased because I use CSV files heavily to both import data to
and
> export data from the Mojam/Musi-Cal database.  It's not the world's best
> data format, but every package I've ever encountered in the database and
> spreadsheet worlds supports it.  I suggest Dave Cole's csv module (fast,
> easy to use, appears complete) be added to the core:

How dare you. ;)

www.sf.net/projects/python-dsv/

This module has heuristics that can determine the delimiter, the text
qualifier as well as whether the first row is a header or data (or you can
provide explicit values yourself).

It correctly parses embedded newlines, embedded quotes, etc.  Basically it
was designed to work with the files generated by MS Excel.

It also has an optional wxPython dialog similar to the one found in Excel
so the user can preview and change the values decided upon by the
heuristics.

As a bonus, it's even easy to use (IMHO).

-- 
Cliff Wells
Software Engineer
Logiplex Corporation (www.logiplex.net)
(503) 978-6726 x308
(800) 735-0555 x308




More information about the Python-list mailing list