ReplaceStr

Description

Returns the string with instances of the old pattern replaced by the new pattern.

Syntax

ReplaceStr(String: String,OldPattern: String,NewPattern: String,ReplaceAll: Boolean): String

String is the string value on which to perform the function.

NewPattern is the string value with which to replace the found string.

OldPattern is the string value to search for.

ReplaceAll specifies whether to replace all occurrences of the search string with the replace string. Valid values: 1, 0, T, F, t, or f.

Example

ReplaceStr(A1;A2;A3,A,B,T)

The return value is B1;B2;B3.