Replace

Replaces all occurrences of one string with another within a specified string.

Syntax

Replace(s1, s2 [, s3 ])

Parameters

Parameter

Description

s1

A source string.

s2

The string to replace.

s3 (Optional)

The replacement string.

If you do not include a value for s3, or if s3 is null, the function uses an empty string.

Examples

The following expressions are examples that use the Replace function:

Expression

Returns

Replace("Tony Blue", "Tony", "Chris")

Chris Blue

Replace("ABCDEFGH", "D")

ABCEFGH

Replace("ABCDEFGH", "d")

ABCDEFGH

Replace(Comments[0], "recieve", "receive")

Correctly updates the spelling of the word receive in the first occurrence of Comments.

// Ethnio survey code removed