|
View previous topic :: View next topic
|
| Author |
Message |
nankrish
New User
Joined: 11 Nov 2005
Posts: 26
|
|
|
|
Hi,
when dowloading from mainframe for few records, details after a period is getting to next line. this is not happening for all records.
also i'm not sure if its a 'period' because the hexadecimal value is x'15' instead of x'4b'.
please help me if you u ve faced similar issues. |
|
| Back to top |
|
 |
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
Pull out your handy EBCDIC-ASCII conversion chart and tell us what an EBCDIC Hex '15' converts to in ASCII.
Then, tell us what was wrong in general. |
|
| Back to top |
|
|
nankrish
New User
Joined: 11 Nov 2005
Posts: 26
|
|
|
|
Thanks a lot superk,
But still have one doudt.
for X'15' , EBCDIC has new line and ASCII has NAK( -ve Acknowledge).
so data will be converted to EBCDIC. tats y its going to next line.
Let me know if my understanding is right. |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
According to the conversion chart I use, the conversion of an EBCDIC X'15' (NL or Newline) is ASCII X'0A' (LF or Line Feed).
Your data has transparency (meaning that it contains hex values less than a space (X'40')) and, as such, it cannot be properly converted from EBCDIC to ASCII. |
|
| Back to top |
|
|
nankrish
New User
Joined: 11 Nov 2005
Posts: 26
|
|
|
|
| can u pls. share the conversion chart u r using.. it seems i'm not using the right one. |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
| I included the url in my last post (click on the highlighted text "conversion chart I use"). |
|
| Back to top |
|
|
nankrish
New User
Joined: 11 Nov 2005
Posts: 26
|
|
|
|
Thanks Superk,
is it possible to check if a value is a junk value then change that to a other value like spaces or periods.. |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
There are all sort of methods you might use.
An easy way is to use ISPF EDIT. Do a FIND for invalid characters (i.e. non-display characters) by using FIND P'.'. Then, you can change the value of any non-display character found to any other value with a CHANGE command, i.e. CHANGE X'15' X'40' ALL. |
|
| Back to top |
|
|
nankrish
New User
Joined: 11 Nov 2005
Posts: 26
|
|
|
|
| is it possble to do simliar check in program instead of ispf edit? |
|
| Back to top |
|
|
|
|
