substring
To return a new string out of a given text with a given start and a given end
This function extracts a part of a text according to your specifications.
You need to provide the start position, where the extract in the given text shall begin and the end of the extract; unlike the function substr() where you can specify the length of the extract. The start is zero-based.
Note: If the end value is smaller than the start value, the smaller number is the start position and the larger one is the end position. The end is exclusive.
Syntax
substring(string, number, number)
Return
string
Examples
substring(text, start, end) To return a new string out of a given text with a given start and a given end. The start is zero-based.
substring('Ninox example', 4, 7) Result: o w
(with the field Ninox example containing the text Hello world!)
See also
substr which returns a new string out of a given text