REPLACE

Returns a new string in which all occurrences of the provided pattern in the provided string are replaced with the provided replacement.

Usage

REPLACE(source, match, replacement)

Parameters

source	String	The string to search.
match	String	The string to replace.
replacement	String	The string to replace with.

Returns

String

Examples

REPLACE(‘Hello Thomas’, ‘Thomas’, ‘Emilie’)

Hello Emilie

Remarks

N/A