Replace

Syntax

Replace(source|find|replace)

Description

Use the Replace function to replace every occurrence of a substring found in a string with a new substring.

Parameters

Parameter Description

source

A string in which you want to replace substrings.

find

A string equal to the substring of source you want to replace.

replace

A string with which to replace occurrences of find in source.

Returns

Returns a string resulting from replacing every occurrence of find found in source with replace.

Example

The following table presents an example of using the Replace function.

Expression Result

replace(“original text”|“i”|77)

Or77g77nal text