Change the value using SYNCSORT.
Posted: Wed Oct 29, 2008 8:45 pm
Hi,
We have some data like this......
I would like to know how to change all the "C.V." to "M.T.". My expected output should be as given below:
Please suggest.
Thanks.
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.
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.
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.