Not bad design at all, and something Text::CSV can perfectly deal with. If the files are indeed that big, consider to also install Text::CSV_XS which is up to 100 times faster than the bundled Text::CSV_PP.

Extra note, if the format is indeed as you've posted, you'd probably also have to look at the allow_whitespace attribute.