Text.Replace

Syntax

Text.Replace(text as nullable text, old as text, new as text) as nullable text

About

Returns the result of replacing all occurrences of text value old in text value text with text value new. This function is case sensitive.

Example 1

Replace every occurrence of "the" in a sentence with "a".

Text.Replace("the quick brown fox jumps over the lazy dog", "the", "a")

"a quick brown fox jumps over a lazy dog"