REPLACE (Report Builder)
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. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Text Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)