REPLACE (Report Builder 1.0)
Returns a string with all the instances of a substring replaced by another substring.
Syntax
REPLACE(find, replace, string)
find |
Specifies the string that contains the substring to replace all instances of with another. |
replace |
Specifies the substring to locate. |
string |
Specifies the substring with which to replace the located substring. |
Example
Formula |
Result |
|---|---|
REPLACE(Description, "steel", "copper") |
Returns each instance of the Description field where the word copper replaces every instance of the word steel. |