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.
substring(string, number, number)
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!)