CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: Advanced: smart csv perl library : Edit Log

New User

Mar 3, 2009, 8:18 AM

Views: 1447
smart csv perl library

I am a data analyst.
I am reading a csv file. Each column in the csv file has a mapping to data based on the column name. e.g.
if csv file is something like:
key, column_b,column_c,column_d,..

then there is a mapping from column_a to a meaningful name coming from another file:
same for column_b, etc..

I need a CSVReader that can be initialized with the mapping files and then be asked to read the csv file, the translation should happen behind the scenes and it should return me mapped column fields.

e.g. usage.

my $csvReader =  new CSVReader(); 
while($csvReader->hasNext()) {
my @columns = $csvReader->readNext();

Is there a library out there that does this smartly and can also take in configuration file specifying how to map column names. If it has other cool features that would be cool too.



(This post was edited by sardare on Mar 3, 2009, 8:19 AM)

Edit Log:
Post edited by sardare (New User) on Mar 3, 2009, 8:19 AM

Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives