Replace

Description

Replace replaces matching text with another value.

Syntax

Replace(text, old_text, new_text)

Parameters

Parameter	Required	Type	Description
text	Yes	String, field, or expression	Source text.
old_text	Yes	String	Text to replace.
new_text	Yes	String	Replacement text.

Notes

Use this function in calculated fields, metric expressions, or query expressions where the function category is supported.

Example

Replace(ProductName, "Old", "New")

The expression returns the calculated result according to the current query context.