G Guest May 24, 2005 #1 Can a string be built that contains a field with a hex value of "00" - spaces give a value of "40".
J JE McGimpsey May 24, 2005 #2 Not sure what you mean, exactly - how did you get your value of "40"? =DEC2HEX(0,2) will return "00"
G Guest May 24, 2005 #3 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"
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 May 25, 2005 #4 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
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
G Guest May 26, 2005 #5 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...
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...
