in reply to CSV Files With Missing Values

There is an actual specification for CSV files known as RFC 4180. That's why people are recommending you use something like Text::CSV_XS.