Replace the characters with DFSORT?

davidllw · New User Joined: 12 May 2005 Posts: 4 Location: China

Can we use DFSORT to search the dataset with a key word, and then replace it by the other word we specify?

i.e.

Input File A:
AAABBBCCDDDEEE
CCCAAABB
CEDCCC

run after the DFSORT coding

Ouput File B:
AAABBB11DDDEEE
111AAABB
1ED111

All 'CCC' change to '111'.

Thanks...
David

Frank Yaeger · Posted: Fri May 27, 2005 6:19 am Post subject:

You say

davidllw · New User Joined: 12 May 2005 Posts: 4 Location: China

Many Thanks...I'll try it tomorrow...:)

davidllw · New User Joined: 12 May 2005 Posts: 4 Location: China

Dear Frank,

I would like to ask one more stupid question. I never use the program highlight below. Is it still the DFSORT?

S1 EXEC PGM=ICEMAN

Frank Yaeger · Posted: Wed Jun 01, 2005 9:31 pm Post subject:

PGM=ICEMAN and PGM=SORT are ways to invoke the primary sort product at your site. If you have DFSORT as the primary sort product at your site, PGM=ICEMAN and PGM=SORT will invoke DFSORT.

davidllw · New User Joined: 12 May 2005 Posts: 4 Location: China

Frank, Thanks for your reply. I've tried your method. It do work. If I want to make a little 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

Frank Yaeger · Posted: Thu Jun 02, 2005 8:41 pm Post subject:

DFSORT doesn't have any built-in functions for doing that kind of find and replace.

<It does as of July, 2008 - see my post later on>

mohitsaini · New User Joined: 15 May 2006 Posts: 41

hello,

Actually I am looking for a replacement for '$' with space (1 Byte only). How do I do that ???

Actually I was referring to the ASCII table for hex equivalent but it was of not help ...

Any kind of help would be really appreciated.

- Mohit

sril.krishy

Hi,
Try this.

mohitsaini · New User Joined: 15 May 2006 Posts: 41

Hi Krishy,

It is working now.

Thanks a ton but tell me one thing .... what table are you are referring to figure out '$' as 5B ...

As I mentioned in my previous message that I referred the ASCII table but couldn't find what you got and what you got is working fine ... so plz do tell me what table you are referring to ???

Thanks once again.

Mohit

Frank Yaeger · Posted: Tue Jun 27, 2006 8:43 pm Post subject:

sril.krishy

Hi,
The simple thing that I do generally is,open any member in EDIT mode and type the letter which you want to convert.

Then use the HEX on function and see it's hex value and use that one in
ALTSEQ CODE.

When you type $0 and use the HEX on ,you can see the values like this.
54
b0

Thank you
Krishy

Frank Yaeger · Posted: Wed Jun 28, 2006 1:13 am Post subject:

Krishy,

Good suggestion. I often do that too.

vinoth_316 · New User Joined: 20 Jun 2006 Posts: 4

Hi all

I am new to Mainframes, 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. Any help???

mohitsaini · New User Joined: 15 May 2006 Posts: 41

What if I want to replace two chars at a time

For example if I want to replace '$' with '0' (zero) and ' '(space) with '0'.

so the input file

abc$a888 9999

would look like:

abc0a88809999

How can we do this in just one step.

Rgds,
Mohit