Contents: | Main | Chapter | See Also: | Getting Started Manual | Programmer Manual |
Format: | TRANSLATE(string,"oldchar","newchar") |
Parameters: |
string is a string expression to be changed. oldchar are the character(s) to be translated. newchar are the character(s) to replace the oldchar. |
Use: | This function alters string by changing each character in oldchar into the character in the corresponding position in newchar. The translation is one character for one character. |
Examples: |
TRANSLATE("08261991","123","ABC")=> 08B6A99A TRANSLATE(NAME,"J","j")=> jOHNSON,jIM |
Reviewed/Updated: March 4, 2007