Returns the substring between a starting and ending position. Both the positional arguments are 1-based.
Syntax
Substring ( string, index1 [, index2 +] )
| Parameter | Description |
|---|---|
string | String to subdivide (or field containing that string). |
index1 | A number n representing a starting position within a string. |
index2 | Optional. A number n representing an ending position within a string. If omitted, the endpoint is assumed to be the end of the original string. |