Page 1 of 1

Change the value using SYNCSORT.

PostPosted: Wed Oct 29, 2008 8:45 pm
by ranga_subham
Hi,

We have some data like this......

1100000122021000011.RAJAEX CHEVROLET,S.A. DE C.V.           
1100000122042000011.AUTO VERMACIAL SICA, S.A. DE C.V.       
1100000122054000011.AUTOS PRONOMICOS, S.A. DE C.V.         
1100000122066000011.EXCELEENTA BUIOMOTRIX, S.A. DE C.V.     


I would like to know how to change all the "C.V." to "M.T.". My expected output should be as given below:

1100000122021000011.RAJAEX CHEVROLET,S.A. DE M.T.           
1100000122042000011.AUTO VERMACIAL SICA, S.A. DE M.T.       
1100000122054000011.AUTOS PRONOMICOS, S.A. DE M.T.         
1100000122066000011.EXCELEENTA BUIOMOTRIX, S.A. DE M.T.     


Please suggest.

Thanks.

Re: Change the value using SYNCSORT.

PostPosted: Mon Jan 26, 2009 8:48 pm
by Alissa Margulies
This can be easily accomplished using the FINDREP feature which is available in SyncSort for z/OS 1.3.2.