PEP 305 - CSV File API

[Carlos Ribeiro]

On Sunday 02 February 2003 09:55 pm, Dennis Lee Bieber wrote:
>         Is anyone working on a csvDB module to plug on top <G> I've
> encountered so many CSVs where the first row was column headers, and
> all rows were similar (no variant field counts, etc.) that being able
> to do something like:

The idea to support column headers is a very good one. It would help to 
implement the dictionary interface with the column names (as some people 
already have asked).

It is also interesting (not mandatory, just interesting!) to see how did 
Microsoft implement this in the latest ADO library - there are DB interfaces 
for both CSV and plain text files. A related idea is to implement in the same 
library the support for generic delimited (CSV is just one case) and fixed 
width text files.

And last, but not least, the CSV library has to take into account other things 
that happen to be problematic, and that are locale-related:

- reading dates from a CSV file
- reading floating point values (the old comma x period dilemma).


Carlos RIbeiro
cribeiro at mail.inet.com.br