Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Completely New To Perl - Need Help Commenting Script

by Jim (Curate)
on Jul 25, 2013 at 18:31 UTC ( #1046406=note: print w/ replies, xml ) Need Help??


in reply to Completely New To Perl - Need Help Commenting Script

I have been given a perl script to quickly extract rows from large excel files.

It's not a well-written Perl script in my opinion. A CSV file is not an "Excel file" just as a text file is not a Notepad file. Pre-counting lines in a large CSV file using a system call to wc -l just to display a silly percentage progress meter is dopey and wasteful. Splitting CSV records using split() is a bad idea in the general case. If the data records are actually in a large Excel workbook to begin with and are being saved to a large CSV file just to run a Perl script on them, then it might be smarter to use DBI with ODBC::DBD and the Microsoft Excel Driver and simply query the Excel workbook directly using an SQL SELECT statement. But if that's the case, then maybe the data should be in a database to begin with.


Comment on Re: Completely New To Perl - Need Help Commenting Script
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1046406]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (13)
As of 2015-07-31 15:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (279 votes), past polls