If you're using MySQL (and I'm sure several others) you can skip this whole step and
use mysqlimport. Run the command without arguments and it'll spit out some help. You
just tell it what the fields are terminated by and it'll split around them and
import into your db. Fast and easy.
Matt
---
i have some csv data:
ex:
1,bart,555 3343 3456,main st
2,john,398 775 ,3rd road
3..
etc... to about 150 or so
anyway, i want to use perl to make the sql statement:
INSERT into $TABLE (field1, field2, field3...) VALUES ('value1','value2','value3'...);
and the values are the csv d