Flowering Weeds

"Frank"

>I seem to get errors unless all
> fields are there, for example in my first
> line, I have the right amount of commas
> but there is no third field:
>
> field1,"field 2,sfd",
> field1,field2,field3
>

Perhaps Microsoft's Log Parser 2.2

PS> LogParser.exe "SELECT field1 AS Item1 ,field2 AS Item2 , field3 AS
Item3 FRO
M testComma.csv" -i:csv -statsff -headerRowff
Item1 Item2 Item3
----------- ----------- ------
field1 field2 field3
field1, abc field2 field3
field1 field 2,sfd <NULL>
field1 field2 field3
PS>

Or perhaps:

PS> LogParser.exe "SELECT field1 AS Item1 ,field2 AS Item2 ,
REPLACE_IF_NULL(fie
ld3,'Yep blank') AS Item3 FROM
testComma.csv" -i:csv -statsff -headerRowff -
o:nat -colSep:" Field blank? "
Item1 Item2 Item3
----------- ----------- ---------
field1 Field blank? field2 Field blank? field3
field1, abc Field blank? field2 Field blank? field3
field1 Field blank? field 2,sfd Field blank? Yep blank
field1 Field blank? field2 Field blank? field3
PS>

Just another way!