| Contents: | Main | Chapter | See Also: | Getting Started Manual | Programmer Manual | |||
| Format: | REPLACE(string,oldstring,newstring) |
| Parameters: |
string is the string expression that will be changed. oldstring is a string expression containing the character(s) in string that will be replaced. newstring is a string expression containing the character(s) that will replace those in oldstring. |
| Use: | This function returns the input string with all occurrences of the oldstring changed to the newstring. The oldstring and newstring can be any length. They do not have to be equal in length. |
| Examples: |
REPLACE("abracadabra","ab","*")=> *racad*ra REPLACE("Name is: XXX","XXX",NAME)=> Name is: SMITH,AL |
Reviewed/Updated: March 4, 2007