Thread: Hex low values
View Single Post
  #5   Report Post  
Brad
 
Posts: n/a
Default

I believe that it is EBCIDIC.

"Chip Pearson" wrote:

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


"Brad" wrote in message
...
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"

"JE McGimpsey" wrote:

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

=DEC2HEX(0,2)

will return "00"





In article
,
"Brad" wrote:

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