I have a requirement to read a CSV file. Normally, no problem, just import CSV and slurp the file up.
However, in this case I want to filter out lines that have fields set to particular values. It would be neat to be able to do something like this. select * from test.csv where status <> "Canceled" Using adodb I can do this, so long as I don't have the where clause. :- ( Is there a reasonable lightweight way of doing this in Python? I could write some python code that is used to filter rows, and inport that from config, but it's not quite as elegant as an SQL route. Thanks Nick -- http://mail.python.org/mailman/listinfo/python-list