REMOVESTRING function

Synopsis
This function removes part of a string.
Variations
REMOVESTRING(String, StartIndex, Count)
Returns the original string with a number of characters from the specified starting index removed.
Parameters
String

Specifies the string to remove characters from.

Supported types: String.
StartIndex

Specifies the position within the string of the first character to be removed.

Supported types: Numeric.
Count

Specifies the number of characters to remove.

Supported types: Numeric.
Returns
Returned types: String.
Examples
1.

The following example removes the word "Design" and the space from the string to return "Matrox Assistant".

  • string = "Matrox Design Assistant"

  • startIndex = 7

  • count = 7

REMOVESTRING(string, startIndex, count)