| 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