Text.Replace
Text.Replace(text as nullable text, old as text, new as text) as nullable text
Returns the result of replacing all occurrences of text value old
in text value text
with text value new
. This function is case sensitive.
Replace every occurrence of "the" in a sentence with "a".
Usage
Text.Replace("the quick brown fox jumps over the lazy dog", "the", "a")
Output
"a quick brown fox jumps over a lazy dog"