Text get wrapped

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.

superk · Posted: Mon Jun 12, 2006 6:23 pm Post subject: Re: Text get wrapped

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.

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.

superk · Posted: Mon Jun 12, 2006 8:05 pm Post subject: Re: Text get wrapped

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.

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.

superk · Posted: Tue Jun 13, 2006 6:01 pm Post subject: Re: Text get wrapped

I included the url in my last post (click on the highlighted text "conversion chart I use").

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..

superk · Posted: Tue Jun 13, 2006 11:19 pm Post subject: Re: Text get wrapped

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.

nankrish · New User Joined: 11 Nov 2005 Posts: 26

is it possble to do simliar check in program instead of ispf edit?