|Come for the quick hacks, stay for the epiphanies.|
Re^7: Pre-process csv files before usingby sk (Curate)
|on Aug 06, 2005 at 23:20 UTC||Need Help??|
I have not used DBI::CSV to comment on issues with "." in names. It seems logical that it will break coz of dots as . is typically not a valid name charcater.
Anyways you need to do an inplace edit of your CSV file before you pass it on to DBI::CSV. The code below demonstrates how to do an inplace edit of your file. This will create a backup of the file (mydata.csv.bak) but you can set the $^I flag to "" to pure inplace effect.
WARNING: In Place edits are dangerous. Test out the code on a sample file before you run it on the original file
Note the header - I have threw in some dots there
After I run the program my mydata.csv becomes this -
The dots in the header are gone but the ones in the data still remain. Now your CSV file is ready for DBI.
Hope this helps!