Joe Brenner wrote: > > CSV is in my experience a very annoying "standard". It > looks so simple that everyone just hacks there own > conversions, and consequently there are minor variations > floating around... e.g. I had to deal with files that had > whitespace after the comma separators, and Text::CSV_XS does > not seem to allow that.
DBD::AnyData does, just set trim=>1 and do everything else as you would with DBD::CSV. > DBD::CSV just uses Text::CSV_XS, by the way, so you don't > gain anything by switching to the DBD version, except > possibly a syntax consistent with what you're already > familiar with as a database programmer. And you can use SQL, and it supports flock on systems that have it, and you don't have to write your own file-opening error code, and you can address things by field names rather numbers... -- Jeff