Home: Perl Programming Help: Intermediate:
Any Inbuilt Library for Data Filtering ?????????



mojo
New User

Aug 24, 2012, 12:15 AM


Views: 3644
Any Inbuilt Library for Data Filtering ?????????

I am getting huge data in the form of a table from database. first column containd unique ID and third column contains some other id. this data is stored in a file
now I want to arrange this data based on the first column id (unique id). Is there any in built library or module that can help

Thanks in advance


wickedxter
User

Aug 24, 2012, 1:49 AM


Views: 3640
Re: [mojo] Any Inbuilt Library for Data Filtering ?????????

you can use sql to return the data by useing ORDER BY column in ur sql statement.


mojo
New User

Aug 24, 2012, 2:29 AM


Views: 3631
Re: [wickedxter] Any Inbuilt Library for Data Filtering ?????????

that file is getting created at run time in my Perl script and also the file is having billions of data. So now I need to process this data and get it arraged in the new file. Do I have any class/module or libray which does some sort of processing or filtering in PERL


FishMonger
Veteran / Moderator

Aug 24, 2012, 6:12 AM


Views: 3615
Re: [mojo] Any Inbuilt Library for Data Filtering ?????????

DBI - Database independent interface for Perl
http://search.cpan.org/~timb/DBI-1.622/DBI.pm

DBD::CSV - DBI driver for CSV files
http://search.cpan.org/~hmbrand/DBD-CSV-0.35/lib/DBD/CSV.pm


Laurent_R
Veteran / Moderator

Aug 24, 2012, 10:52 AM


Views: 3607
Re: [mojo] Any Inbuilt Library for Data Filtering ?????????

Why can't a simple sort of the lines do it for you?