|
This function replaces a specified
substring with another specified substring.
REPLACE(Sring , Find, Replace)
PARAMETERS
String
The original string that contains characters you want to
replace
Find
The ‘substring’ that is contained in STRING that you want to
replace.
Replace
The string which will replace the FIND
string.
Example:
To
replace all references of SALLY to JOHN in the following sentence, and
then save the resulting sentence in the textbox with TAG value of
MODIFIED:
SETVALUE(~MODIFIED~//REPLACE(“Sally
wants what Sally
gets”,”Sally”,”John”)) |