The REMOVE function searches a given source string, removes all instances of a provided search string, and returns the result. As optional behaviors, parameters can be provided to specify whether or not the search is case-sensitive, and to specify the starting position within the source string to begin the search.
| @REMOVE (Source String, Search String [, Case Sensitive [, Start Position]]) | |
|---|---|
Source String | Required string parameter; contains the source string to be
searched by the function. |
Search String | Required string parameter; contains the sub-string to be removed
from Source String. |
Case Sensitive | Optional Boolean parameter; when provided, indicates whether
or not the search of Source String for Search
String should be case-sensitive. If this value is true
or not specified, the search is case-sensitive. If set to false,
case is ignored. |
Start Position | Optional integral number parameter; when provided, specifies
the zero-based position within SourceString to
begin the search. The default is to begin at position 0. |
String