Show TOC

@REMOVELocate this document in the navigation structure

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.
Supported Return Types