Share via


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".

Usage

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

Output

"a quick brown fox jumps over a lazy dog"