subString

Returns a substring from a string expression.

Example

substring("Hello", 2)

In this example, substring returns “llo”.

Syntax

substring(string expr str, int start, [int end])

• str: string to extract a substring from
• start: 0 based starting position for the extracted string

• end: optional last character of the substring to extract

  Returns

  string

Notes

subString returns a substring from str starting at the character given by start and continuing until the end of str. Note that start is zero based. If the optional third parameter end is used, the substring consists of the characters from start to end inclusive.