substr
To return a new string out of a given text
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 (optional) the length of the extract. If you don’t specify the length, the extract will run until the end of the given text. The start is zero-based.
This function helps you to extract parts of identically structured data, for example, invoice numbers; or you can abbreviate values for comparison, for example, Yes and No, which could be shortened to Y and N.
Syntax
substr(string, number)
substr(string, number, number)
Return
string
Examples
substr(text, start) To return a new string out of a given text with a given start. The start is zero-based.
substr('Ninox example', 11)Result: !
(with the field Ninox example containing the text Hello world!)
substr(text, start, length) To return a new string of a given length out of a given text with a given start. The start is zero-based.
substr('Ninox example', 0, 5) Result: Hello
(with the field Ninox example containing the text Hello world!)
See also
extractx which extracts a string from a given text using a regular expression.
substring which returns a new string out of a given text with a given start and a given end.