Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SORT to Find and Replace accent alphabet to normal alphabet

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 141

PostPosted: Thu Jul 24, 2014 11:44 pm    Post subject: SORT to Find and Replace accent alphabet to normal alphabet
Reply with quote

Hi,

I tried to write a SORT to find and replace the below accent characters to normal characters which will be in Name field in my input file .

áÁâÂÄÄáÁãÃåÅ Replace with A
éÉêÊëËèÈ Replace with E
íÍîÎïÏìÌ Replace with I
óÓôÔÖÖòÒõÕ Replace with O
úÚûÛÜÜùÙ Replace with U
ýÝ Replace with Y
çÇ Replace with C
ñÑ Replace with N

& - special character will be converted to the word AND

Code:

//FINDREP JOB(A,B,C),'SRT FRGN',CLASS=S,MSGCLASS=X,REGION=0M,NOTIFY=&SYSUID
//SORT010    EXEC PGM=SORT
//SORTWK01   DD UNIT=SYSDA,SPACE=(CYL,(5,10),RLSE)
//SORTIN     DD DSN=INP.FILE, DISP=SHR
//SOROUT     DD DSN=OUT.FILE,DISP=SHR
//SYSIN DD *
      OPTION COPY
      INREC IFTHEN=(WHEN=INIT,FINDREP=(STARTPOS=44,ENDPOS=100,
      IN=(C'á',C'Á',C'â',C'Â',C'Ä',C'á',C'Á',C'ã',C'Ã'),OUT=C'A'))


/*
//
As i need to continue for other accent characters in IN statement . I would like to know how to do this .  Can any one help me on this .

Thanks
Balaji K
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Fri Jul 25, 2014 12:06 am    Post subject: Reply to: SORT to Find and Replace accent alphabet to normal
Reply with quote

You want to continue a statement? Just break at a comma, and start on the next line. Lots of examples showing that. Or do you mean something else?
Back to top
View user's profile Send private message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 141

PostPosted: Fri Jul 25, 2014 12:09 am    Post subject: Reply to: SORT to Find and Replace accent alphabet to normal
Reply with quote

Hi Bill Woodger,

I meant to continue the IN statements for all accent characters and corresponding OUT statement for its conversion .Please let me know how to do that ?

Thanks
Balaji K
Back to top
View user's profile Send private message
magesh23586

Active User


Joined: 06 Jul 2009
Posts: 213
Location: Chennai

PostPosted: Fri Jul 25, 2014 1:56 pm    Post subject: Reply to: SORT to Find and Replace accent alphabet to normal
Reply with quote

Use multiple IFTHEN=( like this..

I would recommend to use Hex of all these value rather than a character.

Code:

OPTION COPY                                                     
INREC IFTHEN=(WHEN=INIT,FINDREP=(STARTPOS=1,ENDPOS=80,         
IN=(C'á',C'Á',C'â',C'Â',C'Ä',C'á',C'Á',C'ã',C'Ã'),OUT=C'A')),   
IFTHEN=(WHEN=INIT,FINDREP=(STARTPOS=1,ENDPOS=80,               
IN=(C'é',C'É',C'ê',C'ë',C'è',C'È'),OUT=C'E'))                   


Hope this helps.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Fri Jul 25, 2014 3:11 pm    Post subject: Reply to: SORT to Find and Replace accent alphabet to normal
Reply with quote

Either use INOUT and specify all the pairs. Can use symbols/SYMNAMEs to document and simplify code and reduce maintenance.

Or, probably better, use ALTSEQ.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts One-One matching using SORT dearlux SYNCSORT 14 Fri Oct 11, 2019 12:11 am
No new posts Adding FIND to ISPF Panel display of ... Harold Barnes TSO/ISPF 3 Mon Oct 07, 2019 5:46 pm
No new posts Create Dynamic Sort card with Omit co... balaji81_k DFSORT/ICETOOL 9 Thu Sep 26, 2019 10:06 pm
No new posts need assistance on a sort rajiv rengasamy SYNCSORT 11 Fri Jul 26, 2019 8:19 pm
No new posts need help with a tricky sort - Continued rajiv rengasamy SYNCSORT 8 Tue Jul 16, 2019 1:26 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us