using GetString function - Returns EBCDIC codes

[DarkWynd]

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?

 

[remy988]

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

 

[SkipVought]

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

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[DarkWynd]

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...