How to remove null characters(dots) frm the record

rgupta71 · Posted: Mon Jul 27, 2009 3:46 pm

Hi Experts,

Please help me out in sorting a dataset.
The dataset is created by doing ftp and is taking null charactes in the end.
How to remove null characters from the end and in between. Below is the snapshot of the input file.

expat · Posted: Mon Jul 27, 2009 3:52 pm

Hex 40 is a blank.
What is the RECFM & LRECL of the file
Are you looking with BROWSE, VIEW or EDIT

rgupta71 · Posted: Mon Jul 27, 2009 3:56 pm

Hi expat ,
I am looking it in browse mode.
When I am opening it in in view mode it is not showing any dots.

In this step I am converting VB to FB
RECFM is FB and LRECL=80

expat · Posted: Mon Jul 27, 2009 4:19 pm

If you are converting VB to FB, then you should expect to have blanks at the end of the data to make up the FB record length.

rgupta71 · Posted: Mon Jul 27, 2009 4:22 pm

You are right expat.

I used this SORT CARD
SORT FIELDS = COPY
OUTFIL FNAMES=SORTFB, VTOF,OUTREC = (5,80)
But it is showing dots.I don't know the reason.

Thanks.

expat · Posted: Mon Jul 27, 2009 4:34 pm

I have taken your cut and paste from the original post, and the hex representation does not corespond to what is actually shown.

rgupta71 · Posted: Mon Jul 27, 2009 4:43 pm

You are right expat I have just masked the KEY.

Thanks

expat · Posted: Mon Jul 27, 2009 4:48 pm

Well, if the dots are not in the source file, and are there after the ftp process, then you need to investigate why the ftp process adds the dots.

If they are not there, but you your sort card seems OK ......

Robert Sample · Posted: Mon Jul 27, 2009 5:07 pm

You might want to investigate the source of the file. You have hex '05' characters in your file, which are horizontal tab (HT) characters. If the file is starting as a tab-delimited file, you may need to convert each hex '05' to a number of spaces for the file to be properly handled.

dick scherrer · Posted: Mon Jul 27, 2009 8:29 pm

Hello,

If you are receiving this record, one easy thing to do is UNSTRING the content into the needed field using the tab character (x'05') as the delimiter.