Fork()ing and CGI?

2007-07-16 Thread yitzle
I need some guidance... I'm thinking of writing a CGI script that someone can pass some data and set it running. The script may take a few seconds to run. Is it safe/correct/OK to have a CGI script fork, with one thread respondng with a HTTP response while the other thread does its work? I want th

Parsing HTML (Table)

2007-07-16 Thread yitzle
I'm using WWW::Mechanize to retrieve a web page. I get to this line: my $page = $mech->response()->decoded_content(); The page got a with values I wish to extract. What module is best suited to getting to that data? I'm hoping for a somewhat simple to use module. WWW::Mechanize is the first obje

Re: Executing commands through Perl

2007-07-16 Thread John W. Krahn
Teresa Thomas wrote: Hi, Hello, Its my first time (first day actually!) using Perl and I would like some help in performing some relatively simple operations. My program outputs two columns of text based data. I want to parse this information, extract some contents and send the contents (w

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Chas Owens
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote: Thanks for your extra ordinary help guys. Actually, I already run similar type of script which created a spreadsheet with maximum member of rows and columns, the file size was 136 MB, it worked fine. Now you can conclude there is something wrong w

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread a_arya2000
Thanks for your extra ordinary help guys. Actually, I already run similar type of script which created a spreadsheet with maximum member of rows and columns, the file size was 136 MB, it worked fine. Now you can conclude there is something wrong with my script. However, when the script read a txt

Re: Executing commands through Perl

2007-07-16 Thread yitzle
You may also want to look at this: http://perldoc.perl.org/perlipc.html#Using-open()-for-IPC -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Chas Owens
On 7/16/07, Chas Owens <[EMAIL PROTECTED]> wrote: On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote: > By the way, my file size around 22 MB so, is it > possible that Spreadsheet::WriteExcel::Big is not good > enough for this size? snip What follows is a test script you can use to determine if it

beginners@perl.org

2007-07-16 Thread yitzle
I would like to apologize to Tom and the mailing list. I spoke (so to speak) falsely. I wrote ^ and & when I meant line begin and line end. I apologize for the confusion and distress I may have caused. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Ken Foskey
On Mon, 2007-07-16 at 14:23 -0700, a_arya2000 wrote: > I have like around 24K rows. Thank you. Sounds like a design problem. Use a database and connect the excel spreadsheet to that data source. Seems a lot easier. -- Ken Foskey FOSS developer -- To unsubscribe, e-mail: [EMAIL PROTECTED] F

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Chas Owens
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote: By the way, my file size around 22 MB so, is it possible that Spreadsheet::WriteExcel::Big is not good enough for this size? snip What follows is a test script you can use to determine if it is your code or Spreadsheet::WriteExcel::Big (or possi

Re: Executing commands through Perl

2007-07-16 Thread Mr. Shawn H. Corey
Teresa Thomas wrote: Hi, Its my first time (first day actually!) using Perl and I would like some help in performing some relatively simple operations. Welcome to the world of Perl. My program outputs two columns of text based data. I want to parse this information, extract some contents

RE: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread a_arya2000
I have like around 24K rows. Thank you. Arya --- "Wagner, David --- Senior Programmer Analyst --- WGO" <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: a_arya2000 [mailto:[EMAIL PROTECTED] > > Sent: Monday, July 16, 2007 14:06 > > To: beginners@perl.org > > Cc: a_arya2000 > >

Re: Executing commands through Perl

2007-07-16 Thread Chas Owens
On 7/16/07, Teresa Thomas <[EMAIL PROTECTED]> wrote: Hi, Its my first time (first day actually!) using Perl and I would like some help in performing some relatively simple operations. My program outputs two columns of text based data. I want to parse this information, extract some contents and

Executing commands through Perl

2007-07-16 Thread Teresa Thomas
Hi, Its my first time (first day actually!) using Perl and I would like some help in performing some relatively simple operations. My program outputs two columns of text based data. I want to parse this information, extract some contents and send the contents (which are actually program name

RE: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Wagner, David --- Senior Programmer Analyst --- WGO
> -Original Message- > From: a_arya2000 [mailto:[EMAIL PROTECTED] > Sent: Monday, July 16, 2007 14:06 > To: beginners@perl.org > Cc: a_arya2000 > Subject: Re: Spreadsheet::WriteExcel problem with large file > > By the way, my file size around 22 MB so, is it > possible that Spreadsheet::W

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread a_arya2000
By the way, my file size around 22 MB so, is it possible that Spreadsheet::WriteExcel::Big is not good enough for this size? --- a_arya2000 <[EMAIL PROTECTED]> wrote: > Thank you very much for suggestions guys, I tried > using Spreadsheet::WriteExcel::Big but still having > the same issue. I am n

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Chas Owens
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote: Thank you very much for suggestions guys, I tried using Spreadsheet::WriteExcel::Big but still having the same issue. I am not sure, what I am doing wrong. My file size is indeed more than 7 MB. Thank you, Partha Dhar Did you try the suggestion

beginners@perl.org

2007-07-16 Thread Chas Owens
On 7/16/07, John W. Krahn <[EMAIL PROTECTED]> wrote: Chas Owens wrote: > On 7/16/07, yitzle <[EMAIL PROTECTED]> wrote: >> > [ and ] define a character class and ^ means something different >> inside a >> > character class. You need to use alternation instead. >> > >> > =~ /(?:^|&)limit=([0-9]{1,

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread a_arya2000
Thank you very much for suggestions guys, I tried using Spreadsheet::WriteExcel::Big but still having the same issue. I am not sure, what I am doing wrong. My file size is indeed more than 7 MB. Thank you, Partha Dhar --- Raja Vadlamudi <[EMAIL PROTECTED]> wrote: > Use Spreadsheet::Big module if

beginners@perl.org

2007-07-16 Thread John W. Krahn
Chas Owens wrote: On 7/16/07, yitzle <[EMAIL PROTECTED]> wrote: > [ and ] define a character class and ^ means something different inside a > character class. You need to use alternation instead. > > =~ /(?:^|&)limit=([0-9]{1,3})(?:&|$)/ I thought ^ inside [] only meant 'something special' if

beginners@perl.org

2007-07-16 Thread Tom Phoenix
On 7/16/07, yitzle <[EMAIL PROTECTED]> wrote: Call me crazy, but... My code now reads: my $limit; if ( $params =~ /[&^]limit=([0-9]{1,3})$/ ){ $limit = $1; } print $limit; it now matches &limit=3$ but not ^limit=3$ Okay, you're crazy. You haven't put any data into $params, at least in the

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Raja Vadlamudi
Use Spreadsheet::Big module if the file size happens to be larger than 7 MB. The latest Spreadsheet module will have this Big module integrated, but if you are using older version, then you need to use this Big module. On 7/16/07 8:46 AM, "Rob Dixon" <[EMAIL PROTECTED]> wrote: > a_arya2000 wrote

Re: Temporary variables with map { }

2007-07-16 Thread [EMAIL PROTECTED]
On Jul 16, 12:12 am, [EMAIL PROTECTED] (Rodrick Brown) wrote: > @list = map { $c = $_; $c =~ s/\s+/_/g; $c } @d = grep { /\d/ } ; > > Is there a way to shorten the following mostly concerned with why I > have to use a temporary variable. Yes it bugged me too. That's why I contributed List::MoreUti

beginners@perl.org

2007-07-16 Thread Chas Owens
On 7/16/07, yitzle <[EMAIL PROTECTED]> wrote: > [ and ] define a character class and ^ means something different inside a > character class. You need to use alternation instead. > > =~ /(?:^|&)limit=([0-9]{1,3})(?:&|$)/ I thought ^ inside [] only meant 'something special' if it was the first ch

beginners@perl.org

2007-07-16 Thread yitzle
Thanks. I tested your RegEx and it solves the issue. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/

beginners@perl.org

2007-07-16 Thread yitzle
[ and ] define a character class and ^ means something different inside a character class. You need to use alternation instead. =~ /(?:^|&)limit=([0-9]{1,3})(?:&|$)/ I thought ^ inside [] only meant 'something special' if it was the first character. Can you explain what '?:' means? -- To unsu

beginners@perl.org

2007-07-16 Thread yitzle
Call me crazy, but... My code now reads: my $limit; if ( $params =~ /[&^]limit=([0-9]{1,3})$/ ){ $limit = $1; } print $limit; it now matches &limit=3$ but not ^limit=3$ when the RegEx was /^limit=([0-9]{1,3})$/ it matched ^limit=3$ fine -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additio

beginners@perl.org

2007-07-16 Thread Mr. Shawn H. Corey
yitzle wrote: I know this isn't the best way to parse it, but I need to check the $ENV{'QUERY_STRING} for some values. I originally had =~ /^limit=([0-9]{1,3})$/ which worked. But I tried to replace the ^ with [&^] and the $ with [&$] to allow the string to be part of a longer string attached

beginners@perl.org

2007-07-16 Thread John W. Krahn
yitzle wrote: I know this isn't the best way to parse it, but I need to check the $ENV{'QUERY_STRING} for some values. I originally had =~ /^limit=([0-9]{1,3})$/ which worked. But I tried to replace the ^ with [&^] and the $ with [&$] to allow the string to be part of a longer string attached

beginners@perl.org

2007-07-16 Thread Tom Phoenix
On 7/16/07, yitzle <[EMAIL PROTECTED]> wrote: The point is, the [&^] doesn't seem match either ^ or &, like I want to. It works for me. What are you doing that you're not saying? Did you list them in the opposite order? [^&] is a character class matching anything but an ampersand, but [&^] is

beginners@perl.org

2007-07-16 Thread yitzle
I know this isn't the best way to parse it, but I need to check the $ENV{'QUERY_STRING} for some values. I originally had =~ /^limit=([0-9]{1,3})$/ which worked. But I tried to replace the ^ with [&^] and the $ with [&$] to allow the string to be part of a longer string attached with an & on e

Re: Parsing large XML file

2007-07-16 Thread Mike Blezien
Rob, - Original Message - From: "Rob Dixon" <[EMAIL PROTECTED]> To: Cc: "Mike Blezien" <[EMAIL PROTECTED]> Sent: Monday, July 16, 2007 5:04 AM Subject: Re: Parsing large XML file Mike Blezien wrote: Rob Dixon wrote: Mike Blezien wrote: we need to parse some very large XML file

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Rob Dixon
a_arya2000 wrote: Hi, the problem is, when write large spreadsheets of 20,000 rows or so, the module finishes without error, but when I try to open the spreadsheet with Excel I get error messages about the spreadsheet being 'unrecoverably scrambled'. I've never had a problem with it except for t

Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread a_arya2000
Hi, the problem is, when write large spreadsheets of 20,000 rows or so, the module finishes without error, but when I try to open the spreadsheet with Excel I get error messages about the spreadsheet being 'unrecoverably scrambled'. I've never had a problem with it except for these very large sprea

Re: Parsing large XML file

2007-07-16 Thread Rob Dixon
Mike Blezien wrote: Rob Dixon wrote: Mike Blezien wrote: we need to parse some very large XML files, approx., 900-1000KB's filesize. [snip] Your application of XML::Twig seems exactly right. I'm not sure what it is you don't understand, but if you use this as your 'get_products' subrou

Re: Temporary variables with map { }

2007-07-16 Thread Rob Dixon
John W. Krahn wrote: Rob Dixon wrote: my @d = ; my @list = @d; s/\s+/_/g foreach @list; You forgot the grep: my @d = grep /\d/, ; my @list = @d; s/\s+/_/g foreach @list; Yes. Late at night I'm afraid. 2:00am in fact! Thanks for the fix John Rob -- To unsubscribe, e-mail: [EMAIL PROTECT