Replaces all occurrences of the given substring in the text.
textas nullable any,
newas text) as nullable any
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"