rocketperl has asked for the wisdom of the Perl Monks concerning the following question:

Hi I'm a beginner in PERL with basic knowledge but however have not worked with real projects. Right now i have a huge task.I have a ssv document in notepad with atleast 100000 rows! I have to use PERL programming to maipulate this file.In the first place i need to seperate and group this large file into smaller ones based on the data in one of the columns. What command should i use to open the file and do the group by function. Is just the open command enough or should i first create the database (SQL Server) with this data and use the Perl DBI function? Please let me know the method with correct syntax as I am very new to handling files. Thanks a lot

Replies are listed 'Best First'.
Re: PERL DBI
by ww (Archbishop) on Jun 27, 2013 at 11:51 UTC

    How would you do the (first part) if your tools were a printout of the notepad data source, a pencil, sharp knife, and a set of baskets into which to sort the data? Write it out. That's tantamount to the first part of the answer you've asked for.

    Then you'll be ready to start reading (studying!) the list below.

    Those are essential preparations before you start writing your code (and you should not expect the Monks to provide a script to do your [$work/project/homework] -- if, for no other reason -- that that will teach you very little... and teaching is a major reason for the existence of the Monastery).

    So here's some reading:

    Those including the word "perldoc" are available on almost every computer with Perl installed. Simply type the listed phrase at your command prompt.

    And good luck on an exciting endeavor.


    If you didn't program your executable by toggling in binary, it wasn't really programming!