m204prgmr

Lars,

I downloaded the UltraEdit demo and will look at it. It has been years since I've used it and boy has it changed.

Randal,

As always, I admire the hard work you do. thank you

I will try both suggestions.

Lars,

Can you share how you would use ME in conjunction with UltraEdit to totally automate this? Thanks

Good morning,

I keep revisiting this and I'm not sure if it has ever been answered.

I have a flat file formated as follows;

first 6 rows are alpha characters

The Remainder fo the document is numeric, 4 columms.

Below is a paste of what it looks like (edited for HIPAA)

The information below is generated from a custom procedure that can be edited

if need be and is sent to TSO. Retrieval of this and appending an extension is very open. I can say I want it as a .txt or .xls or .csv or .doc or whatever.

My question is this, how do I handle this file so that ME can create it as a .csv and can anyone share how they did it? I have tons of these and it would save hours of time if I automate flat files into .csv.

Thanks,

Robert

CUSTPROC (XXX.DCRREJCT.PAYE)

TYPE E PAYMENT REJECTS FOR XXX AS OF 09-12-2005

------------------------------------------------------------------------

ENCOUNTER SERV DATE TRANS CODE AMOUNT

------------------------------------------------------------------------

123456789a 20050906 XX101253 -137.46

123456789b 20050908 XX101147 7.00

1076261599 20050908 XX101147 -7.00

thank you

I swear CRS is setting in big time.....

I have a simple tab delimited text file containing multiple lines that look like the following;

TSI TSI200 40 0/00.00 0/00.00 0/00.00 1/12.54

TSI TSI300 40 0/00.00 0/00.00 0/00.00 1/12.54

TSI TSI400 40 0/00.00 0/00.00 0/00.00 1/12.54

TSI TSI500 40 0/00.00 0/00.00 0/00.00 1/12.54

TSI TSI600 40 0/00.00 0/00.00 0/00.00 1/12.54

TSI TSI700 40 0/00.00 0/00.00 0/00.00 1/12.54

Each day this text file will either have more lines, less lines, or none.

I would like to append this information to a Excel spread sheet.

Any help would be appreciated

Robert

Thanks Joe and Kevin,

I was on vacation the last few weeks...

Robert

Kevin,

The new text document will edd up containing redundent values that will need to be filtered leaving only unique ones.

I had seen your previous suggestion in Help and was uncertain if entering 9 was the correct way to do it.

The objective of this project is to automate a look up of message numbers from an online audit of 3rd party software running in the mainframe. Each M204.* relates to either informational or error and they will result in return codes GT 00 or none at all. From a DBA standpoint, I don't have all day to review each M204.* number and cross reference it to the manual. But I will take the time to put this information into a easier method of knowing how the nightly batch ran and what caused errors. And, this also lends an opportunity to track occurences of the messages.

Robert

Kevin,

Now that we've determined how to find the starting position, how would you copy 9 characters starting at N1 and place them into a new text document. Can this be done without opening Notepad or wordpad? And sorry for the elemtary questions but I'm having a bad CRS day...lol

Robert

Bada Bing....thank you so much Kevin. That's what I was looking for.

Robert

My code is such;

<BTFBEG:001:000001:000000:C:\Audittest.txt><IFVAR2:1:01:7:M204.><TMVAR2:20:01:00:000:000:C:\junk2.txtT><ENDIF><BTFEND>

And below is what junk.txt looks like. The M204.* values do not all start in the same position.

05176095208 4 0 0 AD /// M204.0342: CTTC: 96.219 11:29:56, 05.080 9:54:20 TSIPROD S99257.TSIP.

05176095208 5 0 0 MS *** M204.2079: MINBUF RESET TO (NSERVS + NSUBTKS) * MAXOBUF + 15 = (1

05176095216 0 0 0 AD /// M204.0075: INITIALIZATION COMPLETED. BUFFERS = 10000

05176095216 1 0 0 MS *** M204.0082: TIMELEFT = 86400.564

I want to pull out only M204.* values. Since each line is going to contain a different M204. value, wouldn't it be best to locate the starting position and go 9 character? Thanks

Robert

Ok, I musta be going koo koo but I thought I could find the starting position of text while processing a text file and now I don't see it. I've processed a text file to pull out only lines containing specific text and append T1 to another .txt file. I now want to process that new file and find the starting position of my particular text, hightling that text and append only that part to a newer document.

Randall thank you. I too thought someone might have jumped in sooner. I'll give your suggestions a try.

Robert

Greeting all - you've been missed

I'm trying to use the FTP command in ME and I'm a little confused.

I connected successfully but when it get to the 'GET' part, I'm being told it cannot create the file for me. With the GET button selected I have two input windows. The top window has this entered, 'TSIP.USER.TSI9999.COMPLRPT.G%T15%V00'

and the lower window has this entered C:\TSI9999\%T15%.txt. Now, the lower window is only asking for a folder and if I do not add a filename, it barfs on that also.

The message I am getting is this;

'TSIP.USER.TSI9999.COMPLRPT.G1175V00' - Cannot create file C:\TSI9999\1175.TXT\'TSIP.USER.TSI9999.COMPLRPT.G1175V00'

You'll notice that the value 1175 has been added and it is from %T15%.

I think one of my questions based on this error message is, is the design such that the system trying to put my retrieved file in its original name into the folder? If so, that's kind of a bummer for me that I cannot rename the incoming as I can using FTP through DOS. Any help is always helpful..

Hi Floyd,

I thought when I wrote the question that the option was there, but I see now it's not. Might be my mistake.

OK, another question then, will macro's run if the PC is locked via CTRL-ALT-DEL?

I forgot to ask, if the keyboard and mouse are locked, is it only for the session and can I use ME to lock a machine out when not running a Macro? If so, is there security where I would have to put in a password to unlock them?

If I lock the keyboard and mouse at the start of a macro, will macro's run?

Happy Easter to all

Thanks Kevin,

I set up a macro against the editor and it works great. If this was not human intervention that started the scheduled macro, any ideas on the disabled feature haveing a glitch? This schedule macro has worked like a charm for the last 8 weeks M-F. The reason I disabled it is because we only need this to run M-F. I suppose I should add code to just bypass the weekend dates but I'm thinking it could be lots of dates between now and the end of the year. Any thoughts on that one too?...

Robert

Scenerio:

At startup ME resides in my system tray (lower right corner of my monitor).

Can the entire editor be password protected from loading and still have a scheduled macro run? I had a incident the other night with a scheduled macro that ran over the weekend but was disabled on Friday before I left work. Either the disable feature has a glitch or someone was nosieing around. Thanks.

Kevin,

I just tested this and it works great. Although my impression of "Startup" is a reboot or PC startup. I changed users and the macro worked and I adjusted my email message accordingly. Thanks again.

Robert

Works well enough for me Kevin, thank you very much.

Robert

Kevin,

I thought I would share that after a week of creative requests, our Desktop admins finally granted me access to this particular PC. This mean access without having a request window open for acknowledgement. Thanks for all of your imput.

Robert

Gentlemen,

Is ME slick enough to send an email if the machine is going to reboot? If so, can multiple macros be in schedule mode to be checking for things? Thanks

Robert

I forgot to mention, we're using excel to view the .csv.

Robert

Randall,

DOH! I feel like Homer Simpson for not thinking about padding, I'll try that.

below is my code..

<IFVAR2:4:49:4:T48><BEGCLIP><TEXTTYPE:%T48%,%T49%,%T1%,%T2%,%T3%,%T4%,%D1%><ENDCLIP><CLIPAT2:0:C:\SDSMIMPORTS\IMPORTREQUESTS\ImportHistory.csv><ENDIF>

Stay tuned please,

Robert

Question for the Guru's.

I'm appending %T2%,%T3%,%T4%,%D2% to a .csv file.

T2 holds text that will not be longer than Len=5

T3 and T4 are the following format - m-dd-yyyy 99:99:99

D2 will come in at 14 decimal places.

My problem is with the Column widths of T3,T4, and D2. I've done a AutoFit and saved, but each time I append to this file, they retun to a width of 8.1. I need the width to be wider....UGH!

Thanks

Robert

Kevin,

I'm struggling a bit trying to figure out the best placement of "If Window Running."

I think this might be my best option and correct me if I am wrong. ME will recognize this window if it is not in focus? I've seen it on the page while the main program is running and it's not active. Here's my scenerio if I may. There's a scedule running indefinetly that checks every 20 minutes to see if a file has been FTP'd to the PC. IF found, it kicks off the main Import program. Inside of the main program other macros are called. Once the main program starts, the If file found macro is disabled, and I see now it does not need to be since only one can run at a time. Correct? My thoughts on the If Window Running addition is that if true, pause the main program, activate the new window (Remote Access Request), to OK that request, then resume with the main program. The remote request can come in at any point during the main run, which remember, is calling other macros during this duration. Make any sense?..do I need to send the code?

Thanks

Robert