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

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

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

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: 92

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 · Posted: Tue Jun 27, 2006 5:33 pm

Hi,
Try this.

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

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

sril.krishy · Posted: Tue Jun 27, 2006 11:38 pm

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

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: 92

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

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

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

Frank Yaeger · Posted: Wed Jun 28, 2006 8:59 pm

vinoth_316 wrote

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

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

IQofaGerbil · Posted: Fri Jun 30, 2006 3:10 pm

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?

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

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

Frank Yaeger · Posted: Fri Sep 05, 2008 9:32 pm