It would be ok if you have control on your input file. If not, and if there are comma in a string, then it won't work.

 "string",2,,"a,b,c",1.234
[download]

The Perl Cookbook has a chapter Parsing Comma-Separated Data which cover the whole thing more thoroughly.