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.

Formula	Result
REPLACE(Description, "steel", "copper")	Returns each instance of the Description field where the word copper replaces every instance of the word steel.