Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

using GetString function - Returns EBCDIC codes

using GetString function - Returns EBCDIC codes

using GetString function - Returns EBCDIC codes

Hello everyone,

I am currently using Excel to gather some data from our Mainfram systems. We are using Extra 6.71 as the Mainframe emulator. Using VBA, I am able to connect to Extra and then use the Function "SendKeys" to get to a specific screen on the mainframe.

The problem however lies when I'm using the function "GetString" (Which should be reading a string from the screen as a given position).

The string I see on the screen is : "JCLEDIT"
The string returned by the GetString function is : "ÑÃÓÅÄÉã"
The ASCII Codes of the string returned by GetString are : 209,195,211,197,196,201,227
After much fooling arround, I realized that those codes are actually the EBCDIC codes of "JCLEDIT"

Anybody knows how to have GetString do the conversion automatically?

If not, what would be a good algorithm to convert EBCDIC to ASCII?

RE: using GetString function - Returns EBCDIC codes

that's some emulator you have. couldn't you build a table as a lookup to convert this?

RE: using GetString function - Returns EBCDIC codes

Have you no setting in your emulator to select ASCII or EBCDIC. I know that there is such with data transfer thru the emulator.


glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: using GetString function - Returns EBCDIC codes

I did not find any settings on my Emulator or within Excel that would fix this issue. It might be worthwhile to note that I'm using MS Excel 2012 (v 14.0.6106.5005 (32 bit))

In the end, I made up my own EBCDIC to ASCII conversion function in order to properly populate the data in MS Excel.

I would, however, prefer not to rely on my own functions for such a trivial thing...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close