Replace

Replaces every instance of a substring within a text value with a replacement value. Category: text Syntax:

Replace([text_column], "substring", "replacement")

Returns: StringColumn Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`string`	`text\|column`	✓ Yes	The text to be searched and modified.
`substring`	`text\|column`	✓ Yes	The substring to be found and replaced.
`replacement`	`text\|column`	✓ Yes	The text that replaces the substring.

Allowed Column Types: STRING, TEXT

Replace([Phone], "-", "")

Removes every dash from each phone number.

Last modified on August 17, 2026