Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Replace the characters with DFSORT?
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
mohitsaini

New User


Joined: 15 May 2006
Posts: 41

PostPosted: Wed Jun 28, 2006 8:35 pm    Post subject: Re: Replace the characters with DFSORT?
Reply with quote

well I am just replying to my post ...

two replacementw would be done like

ALTSEQ CODE=(5BF0,40F0)

also we can have more separated by commas

Thanks,
Mohit
Back to top
View user's profile Send private message
References
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 4579
Location: San Jose, CA

PostPosted: Wed Jun 28, 2006 8:59 pm    Post subject:
Reply with quote

vinoth_316 wrote
Quote:
I have a doubt similar to the question in this thread. I need to find out the low and high values in a file and replace them by space.


If by low values you mean X'00', and by high values you mean X'FF', you can use the DFSORT technique shown previously with:

Code:

   ALTSEQ CODE=(0040,FF40)


If you mean something else by low and high values, you need to be more specific about what exactly you mean.
Back to top
View user's profile Send private message
vinoth_316

New User


Joined: 20 Jun 2006
Posts: 4

PostPosted: Fri Jun 30, 2006 10:30 am    Post subject:
Reply with quote

Hi Frank,

By low values and high values, I do not mean 00 and FF. One of my friends said to find out low values, the command " F P'.' " can be used and this command shows low values in the form of dots, but the hex value of these dots vary(to name some 12, 2D, 05 etc).


Similarly is there any command to find out the high values and also how to replace such characters using space.

Thanks

Vinoth
Back to top
View user's profile Send private message
IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 190
Location: Scotland

PostPosted: Fri Jun 30, 2006 3:10 pm    Post subject: Re: Replace the characters with DFSORT?
Reply with quote

I think what you are describing is the picture-string FIND command for 'invalid' characters
and that what you want to do is change those characters with spaces.

In ISPF edit you would do it such;

C p'.' ' ' all

are you looking for a batch method to do this?
Back to top
View user's profile Send private message
vinoth_316

New User


Joined: 20 Jun 2006
Posts: 4

PostPosted: Mon Jul 03, 2006 1:21 pm    Post subject:
Reply with quote

Hi all,

Yes, I want to replace the invalid characters with blank space, any batch method to do that would be really helpful.

Thanks,
Vinoth
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 4579
Location: San Jose, CA

PostPosted: Fri Sep 05, 2008 9:32 pm    Post subject:
Reply with quote

Quote:
Frank, Thanks for your reply. If I want to make a change as follows. Can the DFSORT also solve it?

Change all 'C' to 'cat' and all 'B' to 'boys'. It means the length may extend.

i.e.
Input:
CAAAC
AACBBC

Output:
catAAAcat
AAcatboysboyscat

Regards,
David


You can now use DFSORT's new FINDREP function available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008) to do this kind of thing quite easily like this:

Code:

//S1   EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file
//SORTOUT DD DSN=...  output file
//SYSIN    DD    *
  OPTION COPY
  INREC FINDREP=(INOUT=(C'C',C'cat',C'B',C'boys'))
/*


For complete details on the new FINDREP function and the other new functions available with PTF UK90013, see:

www.ibm.com/systems/support/storage/software/sort/mvs/ugpf/
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 HoursGoto page Previous  1, 2
Page 2 of 2