OT: Brian Raven

2006-07-21 Thread Josh . Perlmutter
I know it's off topic, but i figure that I might not be the only one who has noticed or maybe it has to do with getting bogged down for a bit and not being able to watch as frequently and try to offer help, but I noticed the last few days that only two (Bill L and Bill W) of the three I'm u

Re: shift-sets in while-loops (perl 5.7.8)

2006-07-21 Thread Josh . Perlmutter
Bill- [EMAIL PROTECTED] wrote on 07/20/2006 07:06:53 PM: > hi josh -- > > In a message dated 7/20/2006 4:56:42 P.M. Eastern Standard Time, > [EMAIL PROTECTED] writes: > > > Gurus- > > i remember using the var setting in the while loop before when i needed to > > do some movement. not sure i

shift-sets in while-loops (perl 5.7.8)

2006-07-20 Thread Josh . Perlmutter
Gurus- i remember using the var setting in the while loop before when i needed to do some movement. not sure if it was pre- perl 5.7.8 or not. could anyone enlighten me as to what i must be completely overlooking that's causing the inside of the while loop t remained untouched? it is as if it

Re: dual-variable pattern matching

2006-07-20 Thread Josh . Perlmutter
responses embedded [EMAIL PROTECTED] wrote on 07/19/2006 06:25:50 PM: > hi josh -- > > In a message dated 7/19/2006 4:22:20 P.M. Eastern Standard Time, > [EMAIL PROTECTED] writes: > > > Gurus- > > > > I'm trying to help a co-worker on reg exp/pattern match issue. > > > > we have a set of i

dual-variable pattern matching

2006-07-19 Thread Josh . Perlmutter
Gurus- I'm trying to help a co-worker on reg exp/pattern match issue. we have a set of items to go through and another set of input that's tested against the first. we need to check that items in the second set are a one-for-one match or subset of the latter. ie: $var1 =~ /$var2/ where thi

Re: attempting to understand an unexpected response from existence testing

2006-06-08 Thread Josh . Perlmutter
Axel and Wayne- Thank you both on the prompt replies. I was thinking that the test would work because it would query the environment. What i was missing is that it skips that for testing existence. Thank you. =o) -a more learned Josh "Axel Mock" <[EMAIL PROTECTED]> 06/08/2006 01:10 PM

attempting to understand an unexpected response from existence testing

2006-06-08 Thread Josh . Perlmutter
Hi again Gurus! I am trying to expand my understanding of perl. i do not understand why the first test fails and the latter two succeed. shouldn't the first succeed as well? -Josh code: #!/usr/bin/perl use strict; # doesn't work if(-e "%systemdrive%\\servicedisk\\tools\\seachange\\SeaPatch.e

RE: Need help with IMG tag containing unbalanced parentheses

2006-05-16 Thread Josh . Perlmutter
Message: 3 Date: Tue, 16 May 2006 11:10:48 -0500 From: "Curtis Leach" <[EMAIL PROTECTED]> Subject: RE: Need help with IMG tag containing unbalanced parentheses To: activeperl@listserv.ActiveState.com Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=us-ascii Nice example program b

Re: seeking functionality

2006-05-11 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 05/11/2006 03:05:11 PM: > Today's Topics: > >1. Fwd: seeking functionality (Jeffrey Abell) > -- > > Message: 1 > Date: Wed, 10 May 2006 18:59:50 -0400 > From: Jeffrey Abell <[EMAIL PROTECTED]> > Su

seeking functionality

2006-05-08 Thread Josh . Perlmutter
Dear Wise Gurus- I just started searching cpan, but this seems like it will be a long drawn out search, so i figured I would ask early. Does anyone know of packages that allow perl to interact with a windows database engine? The following is a vb script example. I'm trying to connect to a db e

extra workbook using Win32::OLE

2006-05-03 Thread Josh . Perlmutter
Dear perl gurus and the one who (literally) wrote the information known on OLE, Jan Dubois- The following code snippet seems to be producing an extra worksheet that is a duplicate of the 4th sheet, but when i fill in the cells nothing gets added after the first line. I am stumped as to what is

Re: ActivePerl Digest, Vol 27, Issue 49

2006-04-26 Thread Josh . Perlmutter
Deane- response embedded. [EMAIL PROTECTED] wrote on 04/26/2006 12:32:01 PM: > Today's Topics: >3. Got this far with regex, now I'm stumped > ([EMAIL PROTECTED]) > -- > -- > > Message: 3 >

Re:

2006-04-20 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 04/20/2006 10:57:32 AM: > Today's Topics: > >1. Re: URL parsing ([EMAIL PROTECTED]) >2. Re: URL parsing ([EMAIL PROTECTED]) >3. Re: URL parsing (Petr Vileta) >5. URL parsing--mayhap the wrong forum? > ([EMAIL PROTECTED]) >6. Re: URL parsing--ma

Re: URL parsing

2006-04-19 Thread Josh . Perlmutter
Deane- quick search of ICANN revealed a listing of the 2-letter domains http://www.iana.org/cctld/cctld-whois.htm and this information on the other TLDS source: http://icann.org/cctlds/ Traditionally, the agreement to implement coordinated policies for the Internet has been informal. As the In

Re: URL parsing

2006-04-19 Thread Josh . Perlmutter
Deane- My response is embedded. -Josh [EMAIL PROTECTED] wrote on 04/19/2006 12:46:24 PM: >1. URL parsing ([EMAIL PROTECTED]) > -- > > Message: 1 > Date: Wed, 19 Apr 2006 10:04:35 -0500 > From: [EMAIL PROTECTED] > Subject: UR

RE: Regexp question

2006-04-12 Thread Josh . Perlmutter
Once more proving that perl has at least as many ways as there are permutations of people trying to skin the cat to skin a cat... [EMAIL PROTECTED] wrote on 04/11/2006 10:49:31 PM: >2. Regexp question (Steve Baldwin) > -- >

Re: ActivePerl Digest, Vol 27, Issue 14

2006-04-10 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 04/09/2006 02:25:18 PM: > Today's Topics: >2. messy regex (Gerald Preston) > -- > -- > > Message: 2 > Date: Sun, 9 Apr 2006 09:32:36 -0500 > From: "Gerald Preston" <[EMAI

Re: renaming file - not so simple? (Gerald Preston)

2006-04-03 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 04/02/2006 03:05:08 PM: > Today's Topics: > >1. renaming file - not so simple? (Gerald Preston) > -- > > Message: 1 > Date: Sat, 1 Apr 2006 16:43:48 -0600 > From: "Gerald Preston" <[EMAIL PROTECTE

re: Extracting numbers from a string

2006-03-22 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 03/21/2006 09:48:28 PM: > Today's Topics: > >7. Extracting numbers from a string (Naresh Bajaj) > -- > -- > > Message: 7 > Date: Tue, 21 Mar 2006 19:28:41 -0600 > From:

Re: exec broken?

2006-03-22 Thread Josh . Perlmutter
M. Francis Paulin- I think the issue is that the machines are handling perl as different users. It looks like it's working but you don't see anything on one, and you do on the other. Well the system could be launching it for the used executing it. if perl executes as user x and only as user

RE: OLE/M$ Excel and finding sheets

2006-03-21 Thread Josh . Perlmutter
Mr Thurn- Thank you! it worked like a charm! -Josh "Thurn, Martin" <[EMAIL PROTECTED]> 03/21/2006 04:10 PM To <[EMAIL PROTECTED]> cc Subject RE: OLE/M$ Excel and finding sheets > it gets this error:Use of uninitialized value in pattern > match (m//) > at compinfo.pl line 234.

Re: OLE/M$ Excel and finding sheets

2006-03-21 Thread Josh . Perlmutter
Mr Rickards et al- I checked the server shortly after to notice that between norton anti-virus and some other things others were running it was 99% cpu usage. running the script again when that dropped to a more reasonable level, the excel resource error was NOT encountered as it moved from the

Re: OLE/M$ Excel and finding sheets

2006-03-21 Thread Josh . Perlmutter
Mr RIckards et al- Thank you. that has helped a LOT. there's 2 issues left. one is a PERL issue I'm not sure how to deal with, the other is an OLE/Excel one in which excel is left up with an error message saying "not enough resources to display" after bringing the workbook up for the second tim

Re: OLE/M$ Excel and finding sheets

2006-03-20 Thread Josh . Perlmutter
Mr. Rickards, MR. Raven et al- I still get some errors and i'm not sure why on the OLE ones. It is not saving/closing on either version, operating on previously existing nore building new. operating on existing: Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. e:\>

Re: OLE/M$ Excel and finding sheets

2006-03-20 Thread Josh . Perlmutter
Mr Rickards et al- I made a checker based on yours when the small function didn't work plugged into the full script. i get these errors e:\lab reports\test45>rem information section is over, turning echo off. Win32::OLE(0.1403) error 0x80020005: "Type mismatch" in METHOD/PROPERTYGET "Worksh

RE: OLE/M$ Excel

2006-03-17 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 03/17/2006 03:05:18 PM: > Today's Topics: > >4. OLE/M$ Excel and finding sheets ([EMAIL PROTECTED]) >5. RE: OLE/M$ Excel and finding sheets (Brian Raven) > -- > -- >

OLE/M$ Excel and finding sheets

2006-03-17 Thread Josh . Perlmutter
For those interested I decided to play around with simply finding a specific sheet and see what happens if i started with the most basic calling by name. the following is my code/errors. On the two times that it asked if there was an added sheet, it created a new workbook instead and did not cr

Win32::OLE/excel errors

2006-03-16 Thread Josh . Perlmutter
dear Gurus- I have some more errors to work through before I'll feel ready to try out pulling out a specific sheet from among many. The following lines produces the errors shown under them. The link is to the full code. line 232 is after any loops the others are in LARGE loops so i'm not sure

RE: OLE/Excel and worksheets

2006-03-16 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 03/16/2006 05:37:53 AM: >1. OLE/Excel and worksheets ([EMAIL PROTECTED]) >7. RE: OLE/Excel and worksheets (Brian Raven) > > -- > -- > > Message: 7 > Date: Thu, 16 Ma

OLE/Excel and worksheets

2006-03-15 Thread Josh . Perlmutter
Since I'm still rather new, I was wondering if anyone with more experience than I could answer a question before i test it and possibly ruin data. On an existing workbook with two or more sheets, is it possible to select a specific sheet by name or create a new one: IE: i need to collect inform

Re: Removing the blank spaces

2006-03-13 Thread Josh . Perlmutter
e string (or to the first \n, but there are no newlines any > more due to the > action of the first substitution) and include those characters in > the $1 capture variable. > if there was a space at the end of the string, it will be a part of $1. > the \s* just after the cap

Re: Removing the blank spaces

2006-03-13 Thread Josh . Perlmutter
n replaces the entire line with $! which is the capture from (\S.*) which is everything that is not the beginning and ending white space. > -- > Naresh Bajaj, Intern, > Cardiac Rhythm Disease Management, > Medtronic Inc., > 763-514-3799 HTH Josh Perlmutter -

Re: WIN32::OLE and M$Excel

2006-03-10 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 03/10/2006 11:21:47 AM: > > One thing I saw... You can replace all that if...elsif...elsif... > elsif... stuff with an imitation switch. Like this: > > for ($Examine[0]) { >/Uptime:\s+(\w.*)/i && do { $ws->Cells($row, "E") > ->{'Value'} = "$1"; last; };

Re: WIN32::OLE and M$Excel

2006-03-10 Thread Josh . Perlmutter
"Lynn. Rickards" <[EMAIL PROTECTED]> wrote on 03/09/2006 07:33:12 PM: > Lynn. Rickards wrote: > > [EMAIL PROTECTED] wrote: > > > > < original message removed for brevity > > > < original reply removed for brevity > > > - Lynn. > < part of reply removed for brevity > > ...just seems to run foreve

Re: WIN32::OLE and M$Excel

2006-03-10 Thread Josh . Perlmutter
"Lynn. Rickards" <[EMAIL PROTECTED]> wrote on 03/09/2006 07:33:12 PM: > Lynn. Rickards wrote: > > [EMAIL PROTECTED] wrote: > > > >> Jan et al- > >> > >> Jan, I have this to you as well as the list because I have noticed > >> your name on a LARGE number of sites talking about WIN32::OLE and the

Re: WIN32::OLE and M$Excel

2006-03-10 Thread Josh . Perlmutter
"Lynn. Rickards" <[EMAIL PROTECTED]> 03/09/2006 06:18 PM To [EMAIL PROTECTED] cc activeperl@listserv.ActiveState.com Subject Re: WIN32::OLE and M$Excel [EMAIL PROTECTED] wrote: > Jan et al- > > Jan, I have this to you as well as the list because I have noticed your > name on a LARGE numbe

WIN32::OLE and M$Excel

2006-03-09 Thread Josh . Perlmutter
ted: 03/02/2006 # Original Author: Josh Perlmutter # Maintainers: # Last Revised: 03/09/2006 # Copyright SeaChange International (tm) my(@comps); my($comp, $date); # standard options/revision information variables # verbo

Re: Perl 5.8.x/Excel via Win32::OLE - file creation.seek issue

2006-03-09 Thread Josh . Perlmutter
able. The executable > should > # be made by the last person to revise the script. The Active State Perl > PDK has > # been used. > # > # Created: 03/02/2006 > # Original Author: Josh Perlmutter > # Maintainers: > # Last Revised: 03/07/2006 > # Copyright SeaChange

perl 5.8.x/Excel vis Win32::OLE - file creation.seek issue

2006-03-09 Thread Josh . Perlmutter
rson to revise the script. The Active State Perl PDK has # been used. # # Created: 03/02/2006 # Original Author: Josh Perlmutter # Maintainers: # Last Revised: 03/07/2006 # Copyright SeaChange International (tm) my

RE: Inserting into an array?

2006-03-08 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 03/08/2006 11:52:39 AM: > Today's Topics: >5. Inserting into an array? ([EMAIL PROTECTED]) >6. RE: Inserting into an array? (Brian Raven) > -- > Message: 6 > Date: Wed, 8 Mar 2006 16:28:22 -

OLE and MS excel

2006-03-08 Thread Josh . Perlmutter
I am getting an error with OLE on trying to open a file and create it. do these have to be done separately? if so, what is the correct way? I don't have the luxury of a machine I can be detrimental to while experimenting. the following is the header of my code, where I try to open the file and

Re: Strange opendir()/readdir() behavior...

2006-03-01 Thread Josh . Perlmutter
>1. Re: Strange opendir()/readdir() behavior... (-alpha-) >2. Re: Strange opendir()/readdir() behavior... (John W. Kennedy) > > > -- > > Message: 1 > Date: Wed, 1 Mar 2006 12:32:13 +0200 > From: -alpha- <[EMAIL PROTECTED

Re: Regular expression ;-)

2006-02-16 Thread Josh . Perlmutter
Walter- Some people (more common with those who are used to linux) will have multiple . in the name, sometimes even using it as a way to differentiate. i have seen old. placed before, or after.. so this could become very complicated very fast. I suggest getting a book on perl's reg exp shorts,

Re: Help! My regexp has gone insane!

2006-02-09 Thread Josh . Perlmutter
[EMAIL PROTECTED] wrote on 02/09/2006 12:39:15 PM: > > > Today's Topics: > >5. Help! My regexp has gone insane! ([EMAIL PROTECTED]) > > > -- > > Message: 5 > Date: Thu, 9 Feb 2006 11:13:03 -0600 > From: [EMAIL PROTECTED] > Subject: Help! My regexp has gone in

Re: Importing into Excel

2006-02-09 Thread Josh . Perlmutter
Reposting for the list since it was caught up due to a change at my company's end. Just another potential solution that some might like. [EMAIL PROTECTED] wrote on 02/08/2006 03:05:15 PM: >3. Importing into Excel (Erich Singer) >6. Re: Importing into Excel (Todd Beverly) > > > > --