Perl

how to execute 30 transactions at a time
hi all, I've a limitation with my database that it wont accept more than 30 queries at a time. i'm passing the queries as an array. if the length of array is more than 30 , then execution is getting failed. how can i implement so that every-time only 30 queries will be loaded and rest will be loaded after thei... 20 Nov 2006 20:18

print to terminal
hi people, I need to print to terminal a long $variable containing text, and of course being longer than the terminal width it produces a truncated word that continues on the next line - I'd like to go newline just on spaces... I wrote an approximated version to "prettyprint" it, but it's so awful that I prefer... 20 Nov 2006 04:52

how to load 'formats' from a file
I am using the `format` command in a reporting module I am writing, and I want to be able to store multiple format pictures in files and then load the needed format from the file. This would be an example session using my modules: $rpt = new Report(); $rpt->title("My Title"); $rpt->formattop("header1.fmt"); #... 8 Dec 2006 14:33

Using Perl to join lines in a file
Hi, I have a file with 100 lines each with one record on each line. The file is as follows: 86274886 81459795 78113464 87882848 78286396 77618550 84180945 74310227 69806585 74111006 80947497 80404769 80377684 80259589 68195927 67187136 67345008 78745575 77970192 77937896 85872999 85954776... 8 Nov 2006 17:12

WIN32::OLE excel date
I need help retrieving the date from excel using the Win32::OLE pm. here is my program... use strict; use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; $Win32::OLE::Warn = 3; # die on errors... my $Excel = Win32::OLE->GetActiveObject('Excel.Application') |... 2 Nov 2006 21:53

longest common substring
Is there a standard algorithm or module which finds the N longest common substrings in a set of text files? Here's the use case: I'm trying to clean up a very old, very large, and very ugly build system which has thousands of unparameterized compile/link commands in hundreds of Makefiles. I want to search them... 2 Nov 2006 09:41

Following a redirect
I am looking at lwp::useragent to follow a redirect, so far I have : #! Perl/bin/perl use strict; use warnings; use Data::Dumper; use LWP::UserAgent; my $ua = LWP::UserAgent->new; $ua->timeout(100); $ua->max_redirect(100); #my $url= 'http://epa.gov/npdes/'; my $url= 'http://www.google.com'; m... 31 Oct 2006 17:04

file convesrions
Hello all I have a question!! there is a file with extension dat (ie *.dat) in my unix environment and i wanted to change this to .xls format i mean i have to transfer this file to an excel sheet and then i need to send this file as an attachment to an email address and all this should be ... 29 Oct 2006 15:04

Encoding problem: Rsquo to a with a hat
I posted a message titled "Best way to remove body/html tag from HTML::Element tree" on Sep 6 2006. Tad McClellan helped me out by referring me to http://perlmonks.org/?node_id=554219 which explains using XML::SAX::Writer. Everything was going well with the tag parsing until I started giving the sax parser spec... 2 Nov 2006 12:20

Remove short words from a string
Hi all! How can I remove all words that have a length that is 3 or less? "a lot of words in this text"; should become "words this text" Is it possible? Leif ... 26 Oct 2006 11:01