Hex low values

B

Brad

Can a string be built that contains a field with a hex value of "00" - spaces
give a value of "40".
 
J

JE McGimpsey

Not sure what you mean, exactly - how did you get your value of "40"?

=DEC2HEX(0,2)

will return "00"
 
B

Brad

When I upload the string from excel to the mainframe and look at the hex
representation of the space I get the value of "40"
 
C

Chip Pearson

A space character is 32 or hex 20, not hex 40. Are you sure your
mainframe file is ASCII text (not EBCIDIC)?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
B

Brad

I believe that it is EBCIDIC.

Chip Pearson said:
A space character is 32 or hex 20, not hex 40. Are you sure your
mainframe file is ASCII text (not EBCIDIC)?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Top