EBCDIC | Technical Info |

General Information - 

Extended Binary Coded Decimal Interchange Code (EBCDIC)

A computer code which uses 8 bits to represent 256 unique characters.

ASCII is the 7 bit code version which can represent 128 unique characters

IBM Mainframe Control Codes for converting EBCDIC to regular numbers

 

EBCDIC	Converts to
{	+0
}	-0
A	+1
B	+2
C	+3
D	+4
E	+5
F	+6
G	+7
H	+8
I	+9
J	-1
K	-2
L	-3
M	-4
N	-5
O	-6
P	-7
Q	-8
R	-9

MS-Access Formula for Converting an EBCDIC string of characters to a normal number

The following MS-Access code is a formula that can be pasted in an access query cell as:

NewNumber : Sgn(11-InStr("{ABCDEFGHI=}JKLMNOPQR",Right([OldNumber],1)))*Val(Left([OldNumber],Len([OldNumber])-1) & Right(Str(InStr("{ABCDEFGHI}JKLMNOPQR",Right([OldNumber],1))-1),1))/100

UNIX Conversions

To change ASCII to EBCCID

dd if=inputfilename of=outputfilename conv=ebcdic

To change EBCDIC into ASCII

  dd if=inputfilename of=outputfilename conv=ascii

© 1997,98,99,2000 www.techadvice.com All rights reserved

---