View previous topic :: View next topic
|
Author |
Message |
sun_job
New User
Joined: 18 Sep 2007 Posts: 73 Location: Bangalore
|
|
|
|
Hi
I would like to know how could we remove Hex values in my input dataset removed .
for eg
1---------------------19-------31
01100028705101GT XF B
there are some hex characters like 'XF' , i want to ahve spaces in the columns 19-31.
Please suggest what to do? |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
there are some hex characters like 'XF' |
Whatever you showed seem to be alphabets. Do you want to replace 19-31 with spaces whatever the data it has?
Thanks,
Arun |
|
Back to top |
|
|
sun_job
New User
Joined: 18 Sep 2007 Posts: 73 Location: Bangalore
|
|
|
|
yes i want to replace 19-31 with spaces whatever the data it has with spaces. can u provide me the snippet for the same. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Sun,
The below SORT job would do whatever you asked for .
Code: |
//STEP1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
----+----1----+----2----+----3----+----4----+----5
//SORTIN DD *
01100028705101GT XF B FFFFFFFAAAAAAAAAAAAAAAAAAA
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
INREC OVERLAY=(19:13X) |
SORTOUT
Code: |
01100028705101GT X AAAAAAAAAAAAAAAAAAA |
Thanks,
Arun |
|
Back to top |
|
|
sun_job
New User
Joined: 18 Sep 2007 Posts: 73 Location: Bangalore
|
|
|
|
Thanks arun for ur help |
|
Back to top |
|
|
|