On Tue, 25 Jan 2011, Sam Hart wrote:
> Yep, that's because my original assumption was that your csv stood for
> "Comma Separated Values" in the absolute most literal sense...
Sam,
I agree, but all the csv files with which I've worked have the literal
strings within double quotes. That distinguishes them from numerics.
> It's looking like I'd probably wind up using python for this after all
> (as Tim suggested), as python's csv module is brainy enough to handle
> stuff like this, for example:
>
>>>> import csv
>>>> crud = csv.reader(open('data', 'rb'), delimiter=',')
>>>> for row in crud:
> ... print row
> ...
> ['27132', '96-A001256', 'BC-0.5', '5/21/1996', 'pH', '8.19', '', 'True']
> ['NULL', '96-A001787', 'BC-0.5', '6/25/1996', 'Alkalinity,
> Bicarbonate', '212', 'mg/L CaCO3', 'NULL']
I've not used that module before so I'll read about it.
Thanks,
Rich
_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug
