Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SUBSTITUTE Function 1
- Thread starter umbogo
- Start date
-
1
- Thread starter
- #3
I have actually just found the answer to my question:
in the SUBSTITUTE function you can have multiple pairs, e.g.
SUBSTITUTE("boat", "b", "c", "a", "o", "c", "b"
= "boot".
First the "b" is changed to "c" in the normal way ("coat", then the "a" is changed to "o" ("coot" and so on. I do not know in which version of Mercator this enhancement was introduced. I do (now) know that there is no limit to the amount of pairs you can have, within machine resources.
Thanks for your interest.
Umbogo
in the SUBSTITUTE function you can have multiple pairs, e.g.
SUBSTITUTE("boat", "b", "c", "a", "o", "c", "b"
= "boot".First the "b" is changed to "c" in the normal way ("coat"
, then the "a" is changed to "o" ("coot" and so on. I do not know in which version of Mercator this enhancement was introduced. I do (now) know that there is no limit to the amount of pairs you can have, within machine resources.Thanks for your interest.
Umbogo
- Status
Similar threads
