IBM Mainframe Forum

by **ranga_subham** » Wed Oct 29, 2008 8:45 pm

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:

Select all

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.

by **Alissa Margulies** » Mon Jan 26, 2009 8:48 pm

This can be easily accomplished using the FINDREP feature which is available in SyncSort for z/OS 1.3.2.

IBM Mainframe Forum

Change the value using SYNCSORT.

Change the value using SYNCSORT.

Re: Change the value using SYNCSORT.