amonotod wrote:
I am wondering if there is any kind of switch that can be passed
to DBD::CSV that will enable it to parse only one EOL at a time?
No, but Text::CSV_XS, which underlies DBD::CSV can easily parse a line at a time.
I think there's discussion of adding something along the lines of "execute for fetch" into DBI which would allow this kind of cursor oriented operation.
We are using DBD::CSV to parse files into databases
Check to see if your RDBMS has a "load" function, that is usually the fastest way to get CSV data into a database.
-- Jeff
