[23104] in Perl-Users-Digest
Perl-Users Digest, Issue: 5325 Volume: 10
daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Wed Aug 6 18:10:39 2003
Date: Wed, 6 Aug 2003 15:10:11 -0700 (PDT)
From: Perl-Users Digest <Perl-Users-Request@ruby.OCE.ORST.EDU>
To: Perl-Users@ruby.OCE.ORST.EDU (Perl-Users Digest)
Perl-Users Digest Wed, 6 Aug 2003 Volume: 10 Number: 5325
Today's topics:
Re: Renaming Files inside a GZ Zip File <mikeflan@earthlink.net>
Re: Renaming Files inside a GZ Zip File <nobull@mail.com>
Re: Renaming Files inside a GZ Zip File <ThomasKratz@REMOVEwebCAPS.de>
Re: Renaming Files inside a GZ Zip File ctcgag@hotmail.com
Replace a word if its not in an html tag (Tim)
Re: Replace a word if its not in an html tag <chesucat@freeshell.org>
Re: Trying to select range for Excel chart <asu1@c-o-r-n-e-l-l.edu>
Re: Trying to select range for Excel chart <member35066@dbforums.com>
weird perl cgi problem (Darrian)
Re: weird perl cgi problem <NOSPAM@bigpond.com>
Win32::ODBC and creating fields <levin.spambox@telia.com>
Re: Win32::ODBC and creating fields <nobull@mail.com>
Re: <bwalton@rochester.rr.com>
Digest Administrivia (Last modified: 6 Apr 01) (Perl-Users-Digest Admin)
----------------------------------------------------------------------
Date: Wed, 06 Aug 2003 16:44:54 GMT
From: Mike Flannigan <mikeflan@earthlink.net>
Subject: Re: Renaming Files inside a GZ Zip File
Message-Id: <3F313115.D2E6EFDE@earthlink.net>
"hymie!" wrote:
> I can't comment on what you may or may not have done "years ago", but you
> are still confused.
>
> GZip is a compression program. You have a file named whatever.tif . If
> you compress the file, then whatever.tif is removed and replaced with
> whatever.tif.gz . You don't specify what you mean by
> >Each time I use one of these files
I'm on a Win2000 box. I got these files mailed to me on a
bunch of CD-ROMS. I store them in my computer. My
WinZip program automatically, or possibly with the help
of an add-on, "unzips" these files. I right click on the file,
drag to my desktop, and select unzip. The file that is
shown inside the gz file (when I double click on the gz
file and WinZip opens it, but does not extract it), goes to
my desktop and the original gz file stays intact where it is.
> but if you uncompress whatever.tif.gz , then it is removed and replaced
> by whatever.tif
>
> The only place the filename is stored is in the filename.
>
> >I'll probably abandon the gz format, and just use the
> >zip that I am so familiar with.
>
> That might be for the best. A tool is of no value unless you can use
> it properly.
I suspect my problem here is that I am on a Windows box.
I also suspect, but hope I am wrong, that this is causing
some people to give up on my posts to this newsgroup.
Someday I hope to get a Linux box going, like I did
about 4 years ago. I got it going OK, but gave up on
it after about 3 weeks for various reasons.
Mike
------------------------------
Date: 06 Aug 2003 17:58:17 +0100
From: Brian McCauley <nobull@mail.com>
Subject: Re: Renaming Files inside a GZ Zip File
Message-Id: <u9n0em4tau.fsf@wcl-l.bham.ac.uk>
hymie@lactose.smart.net (hymie!) writes:
> GZip is a compression program. You have a file named whatever.tif . If
> you compress the file, then whatever.tif is removed and replaced with
> whatever.tif.gz .
> The only place the filename is stored is in the filename.
This is untrue. The GZIP format also allows for the file name to be
stored _in_ the file. This was used on old DOS systems so that
WHATEVER.TIF could be compressed to WHATEVER.TIZ and then restored to
WHATEVER.TIF. I can see no reason why anything but a DOS version of
gunzip would care about the filename stored inside the GZIP file.
This, of course, has nothing to do with Perl.
--
\\ ( )
. _\\__[oo
.__/ \\ /\@
. l___\\
# ll l\\
###LL LL\\
------------------------------
Date: Wed, 6 Aug 2003 19:03:21 +0200
From: "Thomas Kratz" <ThomasKratz@REMOVEwebCAPS.de>
Subject: Re: Renaming Files inside a GZ Zip File
Message-Id: <3f313508.0@juno.wiesbaden.netsurf.de>
DQoiaHltaWUhIiA8aHltaWVAbGFjdG9zZS5zbWFydC5uZXQ+IHdyb3RlLi4uDQoNCj4gDQo+IEda
aXAgaXMgYSBjb21wcmVzc2lvbiBwcm9ncmFtLiAgWW91IGhhdmUgYSBmaWxlIG5hbWVkIHdoYXRl
dmVyLnRpZiAuICBJZg0KPiB5b3UgY29tcHJlc3MgdGhlIGZpbGUsIHRoZW4gd2hhdGV2ZXIudGlm
IGlzIHJlbW92ZWQgYW5kIHJlcGxhY2VkIHdpdGgNCj4gd2hhdGV2ZXIudGlmLmd6ICAuICAgIFlv
dSBkb24ndCBzcGVjaWZ5IHdoYXQgeW91IG1lYW4gYnkNCj4gPkVhY2ggdGltZSBJIHVzZSBvbmUg
b2YgdGhlc2UgZmlsZXMNCj4gYnV0IGlmIHlvdSB1bmNvbXByZXNzIHdoYXRldmVyLnRpZi5neiAs
IHRoZW4gaXQgaXMgcmVtb3ZlZCBhbmQgcmVwbGFjZWQNCj4gYnkgd2hhdGV2ZXIudGlmDQo+IA0K
PiBUaGUgb25seSBwbGFjZSB0aGUgZmlsZW5hbWUgaXMgc3RvcmVkIGlzIGluIHRoZSBmaWxlbmFt
ZS4NCj4gDQoNCk5vcGUhIFRoZSBvcmlnaW5hbCBmaWxlbmFtZSBpcyBzdG9yZWQgaW4gdGhlIGZp
bGUgKHVubGVzcyB5b3UgdXNlIGd6aXAgLW4pLiBZb3UgY2FuIHJldHJpZXZlIHRoZSBmaWxlIHdp
dGggdGhlIG9yaWdpbmFsIGZpbGVuYW1lIG5hbWUgdXNpbmcgdGhlIC1OIChvciAtLW5hbWUpIHN3
aXRjaC4NCg0KRm9yIGNvbXByZXNzICAgLU4gaXMgdGhlIGRlZmF1bHQuDQpGb3IgZGVjb21wcmVz
cyAtbiBpcyB0aGUgZGVmYXVsdC4NCg0KU28gdGhlIG5hbWUgaXMgc3RvcmVkIGJ1dCB1c3VhbGx5
IG5vdCByZXN0b3JlZCBhZnRlciBhIHJlbmFtZSBvZiB0aGUgY29tcHJlc3NlZCBmaWxlLg0KDQpV
c3VhbGx5IHBhY2tlZC1maWxlIG1hbmFnaW5nIHRvb2xzIHNob3cgdGhlIG9yaWdpbmFsIGZpbGUg
bmFtZSB3aGVuIHlvdSBhcmUgImxvb2tpbmcgaW50byIgdGhlIC5neiBmaWxlLg0KDQpEb24ndCBj
YWxsIHNvbWVvbmUgImNvbmZ1c2VkIiB1bmxlc3MgeW91IGFyZSBzdXJlIGFib3V0IHRoZSBmYWN0
cy4NCg0KVGhvbWFzDQo=
------------------------------
Date: 06 Aug 2003 21:33:59 GMT
From: ctcgag@hotmail.com
Subject: Re: Renaming Files inside a GZ Zip File
Message-Id: <20030806173359.577$gS@newsreader.com>
Mike Flannigan <mikeflan@earthlink.net> wrote:
> "hymie!" wrote:
>
> > I can't comment on what you may or may not have done "years ago", but
> > you are still confused.
> >
> > GZip is a compression program. You have a file named whatever.tif .
> > If you compress the file, then whatever.tif is removed and replaced
> > with whatever.tif.gz . You don't specify what you mean by
> > >Each time I use one of these files
>
> I'm on a Win2000 box. I got these files mailed to me on a
> bunch of CD-ROMS. I store them in my computer. My
> WinZip program automatically, or possibly with the help
> of an add-on, "unzips" these files. I right click on the file,
> drag to my desktop, and select unzip. The file that is
> shown inside the gz file (when I double click on the gz
> file and WinZip opens it, but does not extract it), goes to
> my desktop and the original gz file stays intact where it is.
Are you sure they are actually a gzip files, as opposed to WinZip files
that someone named with a .gz at the end?
Anyway, I'd just loop on something like this:
system "zcat $oldfilename.tif.gz | gzip > $newfilename.tif.gz"
(I don't know if zcat actually exists under windows.)
Xho
--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service New Rate! $9.95/Month 50GB
------------------------------
Date: 6 Aug 2003 13:28:52 -0700
From: tim.cavins@sitel.com (Tim)
Subject: Replace a word if its not in an html tag
Message-Id: <dc9a9e04.0308061228.3b6cf4b7@posting.google.com>
What would the regular expression be to replace the word "body" in an
html document as long as it's not in between < and > so it doesn't
replace the actual body tag or anything else with body?
Thanks in advance for any help.
-Tim
------------------------------
Date: Wed, 6 Aug 2003 17:49:11 -0400
From: Chesucat <chesucat@freeshell.org>
Subject: Re: Replace a word if its not in an html tag
Message-Id: <Pine.NEB.4.33.0308061746500.29202-100000@iceland.freeshell.org>
On 6 Aug 2003, Tim asked:
> What would the regular expression be to replace the word "body" in an
> html document as long as it's not in between < and > so it doesn't
> replace the actual body tag or anything else with body?
>
> Thanks in advance for any help.
>
> -Tim
s/body//g
--
chesucat@sdf.lonestar.org
SDF Public Access UNIX System - http://sdf.lonestar.org
Carelessly planned projects take three times longer to complete than
expected. Carefully planned projects take four times longer to
complete than expected, mostly because the planners expect their
planning to reduce the time it takes.
------------------------------
Date: 6 Aug 2003 15:33:00 GMT
From: "A. Sinan Unur" <asu1@c-o-r-n-e-l-l.edu>
Subject: Re: Trying to select range for Excel chart
Message-Id: <Xns93CF757F1D918asu1cornelledu@132.236.56.8>
Graham Wood <Graham.T.Wood@oracle.com> wrote in
news:3F30F689.9E307414@oracle.com:
> hansioux wrote:
>
>> but instead of charting column A all the way through column J
>> I just want to chart column A and column J.
>>
>> $Range = $Sheet->Range("A1:J10")->Select(); only gives the whole
>> thing.
>
> try
> $Range = $Sheet->Range("A:A,J:J")->Select();
>
> This should select column A and column J rather than all columns
> between A and J.
Incidentally, one can figure out the answer to this question by starting
up Excel, and selecting a discontinuous range for a formula, and looking
at what is displayed in the formula bar. Considerably faster than waiting
for someone else to do it and post the solution on the UseNet.
Sinan.
--
A. Sinan Unur
asu1@c-o-r-n-e-l-l.edu
Remove dashes for address
Spam bait: mailto:uce@ftc.gov
------------------------------
Date: Wed, 06 Aug 2003 18:43:12 +0000
From: hansioux <member35066@dbforums.com>
Subject: Re: Trying to select range for Excel chart
Message-Id: <3209386.1060195392@dbforums.com>
It did work, thanks.
Originally posted by Graham Wood
> This is a multi-part message in MIME format.
> --------------6ACA1FB34367523651D886F4
> Content-Type: text/plain; charset=UTF-8
> Content-Transfer-Encoding: 7bit
>
> hansioux wrote:
>
> > Hi,
> > This is probably not an "perl" question, but I am writting this
> in perl,
> > so I gave it a shot.
> > I have created a excel spreadsheet using the Win32::ole..
> > I am trying to create a excel chart,
> > but instead of charting column A all the way through column
> J
> > I just want to chart column A and column J.
> > $Range = $Sheet->Range("A1:J10")->Select(); only gives the
> whole thing.
>
> try
> $Range = $Sheet->Range("A:A,J:J")->Select();
>
> This should select column A and column J rather than all columns
> between A
> and J.
>
> Hope this helps
>
> Graham
>
>
>
> --------------6ACA1FB34367523651D886F4
> Content-Type: text/x-vcard; charset=UTF-8;
> name="Graham.T.Wood.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Graham Wood
> Content-Disposition: attachment;
> filename="Graham.T.Wood.vcf"
>
> begin:vcard
> n:;Graham
> x-mozilla-html:FALSE
> adr:;;;;;;
> version:2.1
> email;internet:Graham.Wood@oracle.com
> fn:Graham Wood
> end:vcard
>
--------------6ACA1FB34367523651D886F4--
--
Posted via http://dbforums.com
------------------------------
Date: 6 Aug 2003 08:38:35 -0700
From: pengwang001@hotmail.com (Darrian)
Subject: weird perl cgi problem
Message-Id: <1c036f7.0308060738.28a5cdd5@posting.google.com>
Hi,
Got this really weird CGI problem. I use CGI module to output feedback
to the user after the user submits the form. This cgi script runs an
executable on the server side and will output the result after running
the executable. It actually outputs some message saying "please wait a
moment..." and then invokes the executable (it takes some time for the
exe to finish. normally 2-3 minutes) So during the period of time
user's browser is still waiting for the result. The problem I got is
5% of the time user browser does not get the result output and just
keeps waiting (connecting logo is active on IE6.0)although I am pretty
sure the output has been sent back (I know this because after the
output is printed out the final thing the CGI script does is cleaning
up temp files it creates. In the case when user does not get the
result output on server side those temp files have all been cleaned up
which means the "print ..." above cleaning up code should have been
executed.)
This is driving me nuts coz it does not happen all the time. Just 5%
of the time and I have no idea what's wrong. I wonder if somebody can
give me some help here.
Thanks.
------------------------------
Date: Thu, 7 Aug 2003 01:47:22 +1000
From: "Gregory Toomey" <NOSPAM@bigpond.com>
Subject: Re: weird perl cgi problem
Message-Id: <bgr7ue$rv71c$1@ID-202028.news.uni-berlin.de>
"Darrian" <pengwang001@hotmail.com> wrote in message
news:1c036f7.0308060738.28a5cdd5@posting.google.com...
> Hi,
> Got this really weird CGI problem. I use CGI module to output feedback
> to the user after the user submits the form. This cgi script runs an
> executable on the server side and will output the result after running
> the executable.
Thank you for your Perl question The answer can be found in the following
state transition diagram http://www.teivovo.com/jokes/jokes029.html
gtoomey
------------------------------
Date: Wed, 06 Aug 2003 15:27:45 GMT
From: Bernt Levinsson <levin.spambox@telia.com>
Subject: Win32::ODBC and creating fields
Message-Id: <mi72jvso7fmvg37kgqopf8a6td2cg0k6tn@4ax.com>
Is it possible with Win32::ODBC to create fields?
If not, what application can I use to do this, except Access?
http://w1.321.telia.com/~u32102551/
------------------------------
Date: 06 Aug 2003 18:00:56 +0100
From: Brian McCauley <nobull@mail.com>
Subject: Re: Win32::ODBC and creating fields
Message-Id: <u9ispa4t6f.fsf@wcl-l.bham.ac.uk>
Bernt Levinsson <levin.spambox@telia.com> writes:
> Is it possible with Win32::ODBC to create fields?
Well, that would rather depend on what you mean by the phrase "create
fields".
--
\\ ( )
. _\\__[oo
.__/ \\ /\@
. l___\\
# ll l\\
###LL LL\\
------------------------------
Date: Sat, 19 Jul 2003 01:59:56 GMT
From: Bob Walton <bwalton@rochester.rr.com>
Subject: Re:
Message-Id: <3F18A600.3040306@rochester.rr.com>
Ron wrote:
> Tried this code get a server 500 error.
>
> Anyone know what's wrong with it?
>
> if $DayName eq "Select a Day" or $RouteName eq "Select A Route") {
(---^
> dienice("Please use the back button on your browser to fill out the Day
> & Route fields.");
> }
...
> Ron
...
--
Bob Walton
------------------------------
Date: 6 Apr 2001 21:33:47 GMT (Last modified)
From: Perl-Users-Request@ruby.oce.orst.edu (Perl-Users-Digest Admin)
Subject: Digest Administrivia (Last modified: 6 Apr 01)
Message-Id: <null>
Administrivia:
The Perl-Users Digest is a retransmission of the USENET newsgroup
comp.lang.perl.misc. For subscription or unsubscription requests, send
the single line:
subscribe perl-users
or:
unsubscribe perl-users
to almanac@ruby.oce.orst.edu.
To submit articles to comp.lang.perl.announce, send your article to
clpa@perl.com.
To request back copies (available for a week or so), send your request
to almanac@ruby.oce.orst.edu with the command "send perl-users x.y",
where x is the volume number and y is the issue number.
For other requests pertaining to the digest, send mail to
perl-users-request@ruby.oce.orst.edu. Do not waste your time or mine
sending perl questions to the -request address, I don't have time to
answer them even if I did know the answer.
------------------------------
End of Perl-Users Digest V10 Issue 5325
***************************************
