replace matching characters with another character using sor

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

hi ,

can you please suggest me on how to replace particular character with new character, using sort

example :-

I need to replace 'where' with 'xxxxx'

------
input :-

where do you stay and where is are you from

output :-

xxxxx do you stay and xxxxx is are you from

--------
note :here 'where' can be present in any position

PeterHolland · Posted: Wed Apr 17, 2013 1:16 pm

Search the forum, lots of examples.

Pandora-Box · Posted: Wed Apr 17, 2013 1:48 pm

What is the Sort product you are using?

Also please check if your sortproduct supports FINDREP or something similar

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

thank you ,, my problem solved using findrep

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

adding to previous querry,

here I got logic to replace one character with another.

how to replace these characters based on an indicator Present at position 1.

ex :

input:

2 where are you from and where do you stay
1 where are you from and where do you stay
2 where are you from and where do you stay

out put:

2 xxxxx are you from and xxxxx do you stay
1 yyyyy are you from and yyyyyy do you stay
2 xxxxx are you from and xxxxx do you stay

note :if 1 in first position then 'where' changed to
'yyyyy'

if 2 in first position then 'where' replaced with 'xxxxx'

thank you,

Pandora-Box · Posted: Wed Apr 17, 2013 2:33 pm

Probably you need to use INREC IFTHEN with FINDREP as a combo

Bill Woodger · Posted: Wed Apr 17, 2013 2:33 pm

Use IFTHEN=(WHEN=(logical expression to identify the case, the FINDREP subordinate to that. Again, many examples.

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

thank you, provided way worked well