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.

See Also

Concepts

Working with Formulas (Report Builder 1.0)

Using Functions (Report Builder 1.0)

Text Functions (Report Builder 1.0)

Report Builder 1.0 How-to Topics

Working with Literals in Formulas and Filters (Report Builder 1.0)

Formatting Data, Text, and Images (Report Builder 1.0)