Replace (Find/Replace)

The Replace function is used to search a string for a substring, and replace that substring with a different string.

Syntax

variable = Replace ( SearchString, SubString, ReplaceString )

Remarks

The new string resulting from this function is stored in the variable.

Parameters

SearchString (Search String)

The string to evaluate.

Type: String or variable

SubString (Part of String)

The portion of the string in the original string that will be replaced.

Type: String or String Variable

ReplaceString (Replace String)

The string that should be used to replace the SubString.

Type: String or String Variable

WARNING: String functions are case sensitive. Uppercase or lowercase can be used to convert to all one case prior to processing the string if desired.