Unable to open executable file:

2003-06-25 Thread SCOTT_SISSON
I am trying to create a free standing exe using perl app. I am on old stuff, perlapp 2.1. Here is the output of what I am doing. Any help is appreciated. C:\Perl>perlapp -s=GenDBLoad.pl -f -v -r -c -e=GenDBLoad Input script name: GenDBLoad.pl Output exe name: GenDBLoad.exe Exe Mode: Freestandi

Re: parsing text

2003-12-10 Thread SCOTT_SISSON
A quick comment as I have not really been following this thread. A report is basically a formatted file with each row formatted differently based on something which is always relatively consistent regarding spacing and offsets. For example, in the report you sent, here are what look like some si

RE: Help with or

2000-11-30 Thread SCOTT_SISSON
Sorry about the typos - I had d/b string inserts on my mind. I don't know where the "=!~" came from - fat fingers I guess. Carl Jolley <[

Re: reading hash from file did not produce expected results

2000-12-06 Thread SCOTT_SISSON
You can also try using a regex $x = '8114,[EMAIL PROTECTED]'; $x =~ /(.*),(.*)/; print "\n \$1 = $1 , \$2 = $2"; produces $1 = 8114 , $2 = [EMAIL PROTECTED] # note comma is from print statement no regex parsing.

Re: Newbie Questions

2000-12-12 Thread SCOTT_SISSON
I personally like the O'Reilly books myself. I have the Perl CD book shelf (6 books on a CD) which I reference frequently. Also, learning about regular expressions will be very useful. I am also reading Mastering Regular Expressions by Jeffrey Friedl (also through O'Reilly) which I find very u

RE: Grasping input parameter off the command line . . .

2000-12-13 Thread SCOTT_SISSON
You can use the Getopt module myscript.pl use Getopt::Long; use vars qw($date); GetOptions('D=s' => \$date); print "\n date is $date"; *** $perl myscript.pl -D="12/21/00" should print date is 12/21/00

RE: Getting date from a file and writing data to a file . . .

2000-12-14 Thread SCOTT_SISSON
You can use the regex that was already suggested or use the unpack statement if the file format will not change. I am not sure which is more efficient (I think unpack is) or if you even care about efficiency. H23234 2000.12.11 00.15.00 10.254.345.345 $TMPLT = "A6 A1 A4 A1 A2 A1 A2 A1 A2 A1 A2

Re: Module question

2000-12-29 Thread SCOTT_SISSON
Thanks to all for their suggestions. I'd rather use an existing function than something I wrote. Is File::Slurp the best option for appending files ??. How will it work with large files, it that a machine memory limitation since it needs the file to be in @array? Or does @r = cache to disk if

Re: MS Access List & other questions

2001-01-04 Thread SCOTT_SISSON
Try www.ezboard.com. I have used it for some VBA questions, I think it may have other MS product boards.. It is not as good as this board but what is? Here is a general question. Recently there was a discussion here on the merits of VB vs. Perl. I do not want to rehash that but I do have a so

Re: regex - conditionals?

2001-01-04 Thread SCOTT_SISSON
I do not think you need to write a regex. I think one of the data modules can do the conversions for you. Try Date-Manip using UnixDate ($olddate"%m/%d/%y %r"). This is the slowest of the Date routines so there may be another one to try. Scott

Re: regex - conditionals?

2001-01-04 Thread SCOTT_SISSON
Sorry my example got the dates backwards. Try this use Date::Manip; &Date_Init ("TZ=EST5EDT"); $sdate = '4/23/1998 4:55:37 PM'; $edate = '6/30/2000'; # -MM-DD HH:MM:SS $edate = &UnixDate($sdate,"%Y-%m-%d %H:%M:%S"); print "\n start date=$sdate, end date=$edate"; gives start date=4/23/1

Re: Finding a mail module ????

2001-01-11 Thread SCOTT_SISSON
I send mail via perl and use MIME::Lite. It works very well for me. Below is a test send, you will see where you need to fill in info relative to your organization. Good Luck Scott use MIME::Lite; $emailto = '[EMAIL PROTECTED]'; $subj = "-T- Testing 123 testing "; $errorline

Re: More efficient way to write?

2001-02-05 Thread SCOTT_SISSON
It looks like you got you answer, but here are a couple of other ideas. Instead of using /i in your regex - you can uc() or lc() the string first - I think this may be more efficient. Also, ['html', 'htm', 'doc'] can be written somehting like /\.htm[l]|\.doc/ (not tested- I think it is the co

Re: Rounding numbers

2001-02-14 Thread SCOTT_SISSON
Here is something directly from the Perl Cookbook (Ram). FYI - The O'Reilly Perl CD Bookshelf is a valuable reference source. It has 6 Perl books on 1 CD with an index for all books. Chapter 2

Re: Help getting rid of duplicate entires in a datafile

2001-02-19 Thread SCOTT_SISSON
A quick suggestion is to put the headlines in a hash and subsequently check if they exist, i.e. something like the following: if ( not exists $headlinelist{$headline} ) { &do _your_stuff; }

Re: hash key with a regexp

2001-02-20 Thread SCOTT_SISSON
Here is something q&d (quick & dirty) that can be a start and can probably be done more elegantly. Scott while () { chomp; # eliminate \n ($v1,$v2) = split /\,/; #get variables next unless ($_);#skip blank lines $hash{$v1}++;# incr

RE: I need Faster way than s/bla/bla/i to remove string. Does tha t exist?

2001-03-01 Thread SCOTT_SISSON
if you are building for speed avoid $&, $' and $` as they make copies of the variable being manipulated (see Freidl's Mastering Regular Expressions ppgs. 273-278 and 281-282). "you could try changing your substitute to a match and either using parens with $1 $2 and so on or you could use $& wit

Re: Install PM

2001-03-07 Thread SCOTT_SISSON
Instead of worrying about what is & is not installed you can try using Perlapp to create freestanding exes. Just a thought "Mauricio Lairet P."

Re: Reading from SQL, Writing to CSV ...

2001-03-21 Thread SCOTT_SISSON
Try Text::CSV_XS; Jones Robert Contr 81 CS/SCK <[

Re: Duplicating Excel Spreadsheet with Perl

2001-04-03 Thread SCOTT_SISSON
The functionality you are talking about is strictly and Excel issue. Given that this is a perl mail list the question probably should not be posted here. The functionality accomplished by activating the cell where you want the colums to remain static and then use the tab Window |Freeze Panes

RE: Please Help!

2001-04-06 Thread SCOTT_SISSON
In the debate of editors, I agree - Notepad is not very useful. I'll put my vote in for UltraEdit32. "Scott F" <[EMAIL PROTECTED]>

Re: $1 question

2001-04-19 Thread SCOTT_SISSON
This may be written cleaner, but it works ($tarfile) = $tarfile =~ /\.(.*)$/; "Purcell, Scott"

Re: $1 question

2001-04-19 Thread SCOTT_SISSON
With s/// this works $tarfile =~ s/(.*)\.(.*)$/\2/; Notice the "\2" vs the $2 since we are using what has been group as a replacement string "Purcell, S

Re: Unable to get Attachment working w/Lotus Notes

2001-06-18 Thread SCOTT_SISSON
I have had success using MIME::Lite. Here is code from a script that works in production today. Some of the "names have been changed to protect the innocent". The script generates a log while processing and then e-mails it to a list of users. use MIME::Lite; . .. . sub SendEmail { my (

Re: getopt arrgh!!

2002-11-14 Thread SCOTT_SISSON
Here is a snippet use Date::Manip; use MIME::Lite; use Net::FTP; # # set time zone so Unix Date calls work # &Date_Init ("TZ=EST5EDT"); use vars qw($user, $pass, $server, $filena, $timeout, $passive, $renwdone, $pause,