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".
Text.Replace("the quick brown fox jumps over the lazy dog", "the", "a")
"a quick brown fox jumps over a lazy dog"