Returns a sub portion of a text value.
Function
result = substring(text, start, count)Arguments
| Argument | Data Type |
| text | string |
|---|---|
| start | integer |
| count | integer |
| result | string |
Comments
Clips a string, beginning at the start position and selecting count characters. The first character of the text is position 1, and if the specified start parameter is less that 1 then the result will begin with the first character of the specified text parameter. Count must be positive, and if it is greater than the number that can be returned with the given text parameter, then the function will return the input text from the start character onward.
Examples
result = substring('Higgs boson experiment', 7, 5) /* result = 'boson' */