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.
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!”.
substr, which returns a new string out of a given text