Replace (string, pattern, txt)

Result Type: Text

Definition: Returns string with every occurrence of pattern replaced with txt.

Examples:  Replace("Munger rhymes with plunger", "ung", "ov")

returns “Mover rhymes with plover”.

See Also:

Dice: Get a subcomponent of a delimited tabular string

Head: Get some elements from the start of a delimited string

Left: Get characters from the start of a string

Mid: Get characters from the middle of a string

Regex_Match: Test whether a string matches a regular expression

Regex_Replace: Replace text in a string using a regular expression

Regex_Search: Find the first match of a regular expression in a string

Right: Get characters from the end of a string

Slice: Get a component of a delimited string

Tail: Get some elements from the end of a delimited string

Trim: Remove whitespace from beginning and end of a string