Text::CSV is not quite flexible enough for that. Its big brother, Text::CSV_XS, will allow carriage returns within fields if you set the 'binary' attribute true.

Text::CSV_XS is used internally by the DBD::CSV driver for DBI. That is, in my opinion, the finest way to handle csv files.