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