So all you have to do (unless you use a CSV module) is split the line and make sure it has nine values.

Be careful. That works until a column has embedded (presumably quoted or otherwise escaped) commas. If splitting on commas always worked, there'd be little need for a module.