|We don't bite newbies here... much|
CSV manipulation with perlby joec_ (Scribe)
|on Mar 09, 2009 at 14:06 UTC||Need Help??|
joec_ has asked for the wisdom of the Perl Monks concerning the following question:
I have a csv file, that potentially could contain 400 "columns" and anything up to 1000 rows. What i would like to end up with is this
CSV at the moment:
Seperate Strings (eventually going into oracle as clobs):
I wont know before hand how many rows/cols the csv has as it depends on the dataset from another app.
What i have tried so far is :
which deals with just the first column. Following this logic, i would have to create an array for each column...there must be a better way.
Any ideas appreciated
Eschew obfuscation, espouse eludication!