m204prgmr

Greetings all, It has been a long time since I've asked for help and a confession of long time no hands on work. My dilema is as follows. How do I merge mulitple .csv documents to form a master. And with that, how do I add to the master each time a new or updated .csv comes in? I will be receiving spread sheets from folks who have been asked to look at Column B (Street Names) and add in a name, address, phone number (Columns D,E,F) of someone that they know who lives on that street. There are 207 rows of street names. Soon, spread sheets will be coming in and I will need create a master sheet. Thanks so much Robert

I've copied a file containing 41 Macros from hospital GH to hospital BH. All of the Nicknames start with GH. Is there a mass way to change the nicknames without haveing to open and edit each one? Thanks, Robert

OKEY DOKE.....I changed using OR to using AND....and it worked. Cheers and welcome to all the newbies.

Greeting and HNY to everyone. I'm trying to use OR in my macro and to NOT print if my %T20% contains BP or OLP. I've uploaded the necessary parts and any help would be appreciated. Robert Using_OR.mex tt2lp.txt Copy_of_TT2LP.txt

Bada Bing thanks Joe Just as you were responding I saw that needed to be done. Cheers from Brecksville Robert

%N1% = 61509 %N2% = 1678676 %N3% = %N1% / %N2% My How can I see the result as .03? Thanks Robert

The objective is to create as many .txt files as there are %N1% variables and to FTP them to the Mainframe. I hope this make sense and I apologize for not stating that earlier

Thanks Kevin I'll try your suggestion tonight. How do I save PT2OKX0%N%.txt %N% times once done? AnnArbor.txt has 63 lines with one word on each line. That's where %T5% is used.

It has been awhile and I'm rusty. I'm trying to save Notepad that I've opened and written to and can't seem to connect the dots. Can someone help? thanks <BTFBEG:005:000001:000000:C:\Documents and Settings\RGHutchinson\Desktop\AnnArbornames.txt><LAUNCHDEL2:0:01C:\WINDOWS\system32\notepad.exe><IVAR2:01:02:FEnter the numberFFCenter:Center><SPKEY:0100><TEXTTYPE:<ALTD>F<ALTU>><TEXTTYPE:A><TEXTTYPE:C:\PT2OKX0%N%.txt<ENTER>><DELAY:10><DIS:<TVAR2:05:02:FEnter the outfile nameFFCenter:Center><TEXTTYPE://PT2MTX0%N1% JOB ,'PT2MT FTP'<ENTER>><TEXTTYPE://STEPNAME EXEC PGM=FTP<ENTER>><TEXTTYPE://*%OPC SCAN<ENTER>><TEXTTYPE://SYSPRINT DD SYSOUT=*<ENTER>><TEXTTYPE://OUTPUT DD SYSOUT=*<ENTER>><TEXTTYPE://INPUT DD * <ENTER>><TEXTTYPE:XXX.29.XX.64 5565<ENTER>><TEXTTYPE:FTISTSC TISTSC <ENTER>><TEXTTYPE: <ENTER>><TEXTTYPE:put 'PT2MT.OUT.%T5%' PT2MT.OUT.%T5% <ENTER>><TEXTTYPE:quit<ENTER>><TEXTTYPE://*<ENTER>><BTFEND>

Hi gang, Situation = ME running on a server. Macro starts fine, DOS window opens but then looses focus so ME does not know what to do aborts. Any help would be appreciated. I've gone so far as to move the mouse to the title bar and click on it in the macro and use Window Restore. Thanks, Robert

Chris, I am running ME on a server which is at a remote location. For ME to work for me as the Admin, I disconnect from the server instead of signing off. The problem I am having with one of my macros is using DOS. The window comes up but somehow looses focus. When i return to see why I have not been sent an email, the title bar is greyed out. Robert

Leo, I just tried something with Repeat and without repeat and I'm not sure you will be able to achieve what you want unless you're prepared to go in order. Each wait except for the first is dependent on the previous it appears and if you put time on the delay, you'll get a timeout message. Maybe some of the more experienced members can jump in and lend some advice. Good Luck my friend! Robert

Leo, Try this <IFOTH:01:2:C:\write.txt><DOFILE:08:NN:c:\write.txt>><ENDIF><WAITKEY2:000000:000000:27><TVAR2:01:01:drum><TMVAR2:20:01:00:000:000:c:\write.txtT><WAITKEY2:000000:000000:28><TVAR2:02:01:guitar><TMVAR2:20:02:00:000:000:c:\write.txtT><WAITKEY2:000000:000000:29><TVAR2:03:01:banjo><TMVAR2:20:03:00:000:000:c:\write.txtT> Robert

I found it. Under Debug the Use Test Window option was selected. Mussta been da boogie man that turned that on because I sure didn't... Robert

Leo, I use Variable modify string, then select option 2 on the tabs, then append. <TMVAR2:20:20:00:000:000:C:\ReturnCodes\Jobs%T99%.txtT>