How to capture output

nkwhftw · Post by **nkwhftw** » Thu Sep 01, 2005 5:11 pm

When I run the macro to obtain an output I am having a problem in capturing the data. Is there a way to capture the output in a text format and place it in Notepad. If I use the cntrl keys it takes a picture of the data in which I can not import into an Excel sheet. I have found I can Left click and encompass the data then "copy" and "paste" into Notepad. That seems cumbersome at best. I would like to know how to auto capture the data.

Thanks,

CEW

Bob Hansen · Post by **Bob Hansen** » Thu Sep 01, 2005 5:55 pm

Lots of good help available here, but your question is not clear.

You need to be more specific about what you are trying to do.
What programs are you using? What version of Macro Scheduler?
What are you trying to accomplish?
How are you trying to do that?

Provide a copy of the macro you are using.
Point out what section is not working as you expect it to.

support · Post by **support** » Thu Sep 01, 2005 6:01 pm

"the macro"?
"an output"?
"the data"?

Which macro, what output and which data?

Please explain what you are trying to achieve, what your macro does or has to do and what the problem is.

nkwhftw · Post by **nkwhftw** » Thu Sep 01, 2005 6:26 pm

I have a Telnet session (3270), in which it returns my requested data which is shown on the screen in columns and lines. I am using RUMBA to access the session. My PC is Windows XP. My Excel is 2000. Sometimes the data is too large to appear on one screen it will be either several additional pages and some times the columns exceed up to 120 caracters. 100 lines by 120 caracters is not uncommon.

The system does not allow me to save the data or print the same. I would like to capture that data that appears on the screen and move it over eventually to an Exel spread sheet. The screen appears to be ASCII and is driven by my requested data.

The Macro Scheduler Pro 7.3.11.4 is the vehicle, and I am using script editor to build the macro.

Me_again · Post by **Me_again** » Thu Sep 01, 2005 6:31 pm

So you can't use a telnet client that has data capture?

support · Post by **support** » Thu Sep 01, 2005 7:42 pm

Most TELNET clients let you highlight the contents of the screen and copy to the clipboard. The standard Microsoft telnet client certainly does. So you can send the keystroked to select-all and then edit/copy and then use GetClipBoard to retrieve the data. Then parse it.

Me_again · Post by **Me_again** » Thu Sep 01, 2005 8:31 pm

The microsoft client also has text capture to a file that could be automated. The poster is using Rumba but I would be surprised if that doesn't have a capture function too.

How to capture output

How to capture output

Capture data