Re: Need to process Excel sheet through Perl

2009-12-03 Thread 小兰
On Fri, Dec 4, 2009 at 3:40 PM, Parag Kalra wrote: > Hello All, > > I am looking for some good Perl modules to process excel sheets. > Hi, If you just want a module, take a look at this one (I once used it): http://search.cpan.org/~jmcnamara/Spreadsheet-ParseExcel-0.55/lib/Spreadsheet/ParseExce

Need to process Excel sheet through Perl

2009-12-03 Thread Parag Kalra
Hello All, I am looking for some good Perl modules to process excel sheets. I have a very basic requirement – I need a method to which I would provide the excel sheet and any column name of that excel sheet. It should return the list of all the elements present in that column which I can store ma

Re: speed test

2009-12-03 Thread 小兰
On Thu, Dec 3, 2009 at 11:41 PM, Raymond Wan wrote: > > Hi Xiao, > Hi Raymond, Thanks for the info. Again, my name is "Xiaolan Foo", "xiao" means "small", "lan" means "orchid". So the union of "xiaolan" is my first name, and "foo" is my last name.:-) > > Also, with both languages, you will ha

conditional index of arrays

2009-12-03 Thread Eric Mooshagian
Dear All, This is my first post. I present some subroutines that 1) create an index for one or more arrays and then 2) get summary statistics based on the index. I have 2 issues: 1. I would like to be able to create the index conditional on the values of another array, e.g., conceptuall

Re: speed test

2009-12-03 Thread Uri Guttman
> "UG" == Uri Guttman writes: > "m" == matt writes: m> So...I've proved that in my specific environment, C is (~3x) faster m> than Perl at adding 1+1...Now as far as what tests you want to m> implement, that's up to you and your specific needs. UG> sorry, you haven't proved an

Re: return {}->{'name'};

2009-12-03 Thread Dermot
2009/12/3 Peter Scott : > On Mon, 30 Nov 2009 14:36:44 +, Dermot wrote: Does it have a name? > > It's called the Orcish Maneuver ("or-cache").  See: "Effective Perl > Programming", Hall with Schwartz. Thank you. Interesting there's a edition published in 1998 by Hall/Schwartz and an edition

Re: speed test

2009-12-03 Thread Raymond Wan
Hi Xiao, Orchid Fairy (兰花仙子) wrote: reach each line of every file (many files, each is gziped) look for special info (like IP, request url, session_id, datetime etc). count for them and write the result into a database generate the daily report and monthly report I'm afraid perl can't finish

Re: return {}->{'name'};

2009-12-03 Thread Peter Scott
On Mon, 30 Nov 2009 14:36:44 +, Dermot wrote: > sub get_cached_val_or_lookup { > my $val = shift; > return $cache{$val} ||= do { Could be more effective in 5.10 with return $cache{$val} //= do { to avoid repeating the fetch for values that are false. > One more question If I can.

Re: Insecure $ENV{PATH} message

2009-12-03 Thread Peter Scott
On Sun, 29 Nov 2009 20:12:08 +, Huub van Niekerk wrote:\ > On Sun, 29 Nov 2009 14:30:47 -0500, Shawn H Corey wrote: > >> Huub van Niekerk wrote: >>> Hi, >>> >>> I started getting this error after upgrading from Fedora 11 to 12. The >>> line of code hasn't been changed: >>> >>> open my $LPR,

Re: how to write a debug-print sub with one argument?

2009-12-03 Thread Peter Scott
On Sat, 28 Nov 2009 02:41:06 -0800, Mark_Galeck wrote: > OK, I tried SmartComments, I must not be understanding something, I > followed the man page exactly, but it does not seem to work: > > use Smart::Comments; > > sub foobar { > ### at ... > ### $_[0] > } > > foobar 1; > > > and when I run

Re: speed test

2009-12-03 Thread Shlomi Fish
Hi Xiao! On Thursday 03 Dec 2009 14:19:10 Orchid Fairy (兰花仙子) wrote: > Thanks all. > How about the files parsing with huge size (about 1T of each day)? > > The basic logic is: > > reach each line of every file (many files, each is gziped) > look for special info (like IP, request url, session_id

Re: speed test

2009-12-03 Thread Rob Coops
On Thu, Dec 3, 2009 at 1:19 PM, Orchid Fairy (兰花仙子) wrote: > Thanks all. > How about the files parsing with huge size (about 1T of each day)? > > The basic logic is: > > reach each line of every file (many files, each is gziped) > look for special info (like IP, request url, session_id, datetime

Re: speed test

2009-12-03 Thread 兰花仙子
Thanks all. How about the files parsing with huge size (about 1T of each day)? The basic logic is: reach each line of every file (many files, each is gziped) look for special info (like IP, request url, session_id, datetime etc). count for them and write the result into a database generate the da

Re: speed test

2009-12-03 Thread Shlomi Fish
Hi matt! On Wednesday 02 Dec 2009 18:29:53 matt wrote: > On Dec 1, 8:58 pm, practicalp...@gmail.com wrote: > > Hello, > > > > Maybe it's not so suitable to ask this here. > > But is there a good way (code sample?) to implement a speed test > > between Perl and C? > > For a project which handles lo

Re: speed test

2009-12-03 Thread Uri Guttman
> "m" == matt writes: m> To perform the test, I'd just use 'time': that is a very poor way to compare speed. it doesn't account for perl's startup time vs running time. m> test.cc: m> int main() m> { m> int a = 1 + 1; m> } m> test.pl: m> #!/sw/bin/perl m> $a = 1

Re: I LOVE HASH(ES)!!! *<:-D

2009-12-03 Thread Shlomi Fish
On Thursday 03 Dec 2009 06:10:46 Anant Gupta wrote: > I second Aimee. > Hashes are awesome. > I should note that we have a page about hashes on the Perl Beginners' Site: http://perl-begin.org/topics/hashes/ It contains a presentation by "Jerusalem Perl Monger" about hashes that enumerates thei

Re: speed test

2009-12-03 Thread matt
On Dec 1, 8:58 pm, practicalp...@gmail.com wrote: > Hello, > > Maybe it's not so suitable to ask this here. > But is there a good way (code sample?) to implement a speed test > between Perl and C? > For a project which handles lots of data we want to know how slower > perl is than C. > > Thanks. T