REPLACE

Concept Link IconSee alsoConcept Link IconExample

Search for, and replace, a sub-string.

WebVue support - Yes.

Syntax

StrVal = REPLACE (InputString, OldSubString, NewSubString[, CaseSensitive[, OccurrenceCount]]);

Return type: STR.

Argument

Meaning

InputString

The input string. Maximum length 32000 characters. Type STR.

OldSubString The sub-string to search for. Maximum length 2047 characters. Type STR.
NewSubString The replacement sub-string. Maximum length 2047 characters. Type STR.
CaseSensitive A flag indicating if the search is to be case sensitive.
0 = Ignore case (default).
1 = Match case.
OccurrenceCount The maximum number of occurrences of the OldSubString to replace. Any numeric type.

Execution

Action

Search the InputString for occurrences of OldSubString and replace with NewSubString.
Return: The modified string.