Re: Process Interaction

2003-09-23 Thread Adam Ingerman
On Wed, 24 Sep 2003 02:39, Buck, Steve wrote: > I need to launch a text based DOS application process on Win2K, then > interact with it. I need to send keystrokes to it and read results so I can > test the DOS application. > > Can you help direct me to what modules/methods I should consider. > > I'

Re: The Unofficial Perl Win32 Users Flameware/Mega-Thread FAQ

2003-09-23 Thread Ted S.
Michael D. Smith graced perl with these words of wisdom: > We're definitely in for it now. Whip out the spam filters and prepare > to weather the storm. Oh, I've already got my spam-filter in action for that [EMAIL PROTECTED] Swen worm. :-) See as well my post from the 18th titled "Regex humor

Re: Parsing Excel file

2003-09-23 Thread Trevor Joerges [SendMIME Software]
Sorry about that Greg. You can try tab delimited and split on \t.   Trevor - Original Message - From: Greg Wardawy To: Perl-Win32-Users (E-mail) Sent: Tuesday, September 23, 2003 11:30 AM Subject: Re: Parsing Excel file Thanks Trevor, Do you know how to

Re: Parsing Excel file

2003-09-23 Thread Greg Wardawy
Thanks Lee, It is, probably, a good time to learn Excel OLE but, unfortunately, I have no time. That's not for my boss, that's for my wife so I can't say "I quit". Greg - Original Message - From: "Lee Goddard" <[EMAIL PROTECTED]> To: "Greg Wardawy" <[EMAIL PROTECTED]>; "Perl-Win32-Users (

Process Interaction

2003-09-23 Thread Buck, Steve
Title: Process Interaction I need to launch a text based DOS application process on Win2K, then interact with it. I need to send keystrokes to it and read results so I can test the DOS application. Can you help direct me to what modules/methods I should consider. I've looked at tons of mai

RE: The Unofficial Perl Win32 Users Flameware/Mega-Thread FAQ

2003-09-23 Thread Arms, Mike
Michael D. Smith [EMAIL PROTECTED] wrote: > You will recall the current mega-thread started not with a > question but a mention of "it" in jest. I hesitate to say > "it" for obvious reason but since everyone knows what "it" > means, that may not matter. We may all be doomed to lifetime > filled w

Re: Parsing Excel file

2003-09-23 Thread Greg Wardawy
Title: Message sorry to all of you about the HTML posts, I've changed the machine and forgot to change OE settings. And thanks for all your help.   Greg - Original Message - From: Adam R. Frielink To: Greg Wardawy ; Perl-Win32-Users (E-mail) Sent: Tuesday, September

Re: Parsing Excel file

2003-09-23 Thread Lee Goddard
I've never used Excel so I'd use DBI and DBD::CSV to do it. The mod's got an Excel example included. Or Text::CSV_XS. But maybe now's a good time to learn Excel OLE. At 16:34 23/09/2003, Greg Wardawy wrote: Hello all, I'm not a big fan of Excel files so I was always saving them as csv files before

Re: Parsing Excel file

2003-09-23 Thread Greg Wardawy
Thanks for your reply, Peter The data in the csv looks like this: ### Customer,Note,Phone Numbers,Email,Full Name,Billing Address,Shipping Address18 International,,"Phone: (212) 586-8863Fax: (212) 262-4030",,Mr. Tim Longdale,"

RE: Parsing Excel file

2003-09-23 Thread Adam R. Frielink
Title: Message In the future, please post in plain text too.   I have had great success with Win32::ODBC and the TEXT::CSV_XS routines for parsing and manipulating csv files.   Using Win32::ODBC, you can pull your records from the Excel file directly and write them back out to the format yo

Re: The Unofficial Perl Win32 Users Flameware/Mega-Thread FAQ

2003-09-23 Thread Michael D. Smith
You will recall the current mega-thread started not with a question but a mention of "it" in jest. I hesitate to say "it" for obvious reason but since everyone knows what "it" means, that may not matter. We may all be doomed to lifetime filled with hundreds of emails about "it." With that in mi

Re: Parsing Excel file

2003-09-23 Thread Greg Wardawy
Thanks Trevor, Do you know how to save Excel file using "|" instead of comma? I'm looking for it in Excel Help but no luck so far.   Greg - Original Message - From: Trevor Joerges [SendMIME Software] To: Greg Wardawy ; Perl-Win32-Users (E-mail) Sent: Tuesday, Septem

RE: Parsing Excel file

2003-09-23 Thread Peter Eisengrein
What does the data look like in the csv as it is currently saved? I am not sure but my hunch is that the modules you loaded will work only if the file is saved as xls. So, unless you open those files with Excel and do a "Save As" xls, you will probably want a parser...     -Original M

OT:Re: Perl editors

2003-09-23 Thread lgbarr
Ah!!! Nostalgia!!! :c) You guys reminded me of one of my favourite tools I had in my toolkit for editing - a steam iron. Twas great for getting you punch cards read by the punch card reader. No self respecting support analyst would be found without one :c) Cheers, /Luiz G

Re: Parsing Excel file

2003-09-23 Thread Trevor Joerges [SendMIME Software]
I would just save it from Excel using something other than a comma delimiter, because your NOTE field has commas in the data, and just split each line on the delimiter you choose like a pipe perhaps "|".   You will of course have to do some other regex magic to parse the NOTE fields into DATE

Parsing Excel file

2003-09-23 Thread Greg Wardawy
Hello all, I'm not a big fan of Excel files so I was always saving them as csv files before working on the data. Well, it got me two days ago, I tried my old ways and wasn't able to find the right one and I need your advice. Here is the situation: 1. I have an Excel file in format like below

RE: Perl editors

2003-09-23 Thread Ken Cornetet
I guess I'm old then, because I've actually done that. On my first co-op I used an ancient HP 2100 mini computer (with 8K 16 bit words) of *core* memory (that was when memory was really memory - it didn't go away when you turned the machine off). That machine didn't have any sort of boot rom built

RE: Perl editors

2003-09-23 Thread Lynn. Rickards
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > $Bill Luebkert > Sent: Monday, September 22, 2003 8:39 PM > To: [EMAIL PROTECTED] > Subject: Re: Perl editors > > > Cameron Dorey wrote: > > > REAL (old) men use the toggle switches on the front of t

Re: Perl editors

2003-09-23 Thread Cameron Dorey
Tillman, James wrote: I use ptked! It's the best! Watch your language! This is a family mailing list. (Just kidding...) jpt Cameron -- Cameron Dorey Editor, Analytical Sciences Digital Library http://www.asdlib.org Associate Professor of Chemistry University of Central Arkansas Phone: 501-450-5

Re: Perl editors

2003-09-23 Thread Cameron Dorey
$Bill Luebkert wrote: Cameron Dorey wrote: REAL (old) men use the toggle switches on the front of the box! A fellow operator and myself used to clear core on IBM 360's - simultaneously reaching and flipping toggles and pushing buttons (memorized and choreographed to perfection - arms crossing e

RE: Perl editors

2003-09-23 Thread Tillman, James
I use ptked! It's the best! (Just kidding...) jpt ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

The Unofficial Perl Win32 Users Flameware/Mega-Thread FAQ

2003-09-23 Thread Lee Goddard
It's that time of year again: please allow me to present the *Unofficial* Flameware/Mega-Thread FAQ, posting II: Feel like a bit of a tussle? Feel like avoiding one? Here's a handy cut-out-and-keep list of favourite fighting-talk subjects for this list: * HTML e-mail and your right to choose

RE: Perl editors

2003-09-23 Thread Gijs Calis
As we're all having a ball with our own editors, I'll throw in mine: UltraEdit (www.ultraedit.com). Very powerful editor. And with a bit of plugging and macro-ing, it will do anything a IDE could do for you. Supports heaps of languages. -Original Message- From: Beckett Richard-qswi266 [ma

Re: [perl-win32-users] unvailable for a moment

2003-09-23 Thread Lee Goddard
Yes, it was a silly question :) Look at the bottom of your own message; or - as always - check the mail headers. hth lee At 09:55 23/09/2003, theatre wrote: hi, is there anyone who can tell me how to unsuscribe ? yes, I know, it is stupid as a question, but my machine has crashed ... and I ha

[perl-win32-users] unvailable for a moment

2003-09-23 Thread theatre
hi,   is there anyone who can tell me how to unsuscribe ? yes, I know, it is stupid as a question, but my machine has crashed ... and I have lost lots of my data ... so I need a break.   please, help, alain.   Message du 23/09/03 03:55 De : Will of Thornhenge <[EMAIL PROTECTED]>A : [EMAIL PROTECTED