SUBSTR

Deprecated version

This document refers to a deprecated version of the RQL programming language.

Please go here for documentation related to the latest supported version.

Extract a substring from a string, given the start index and length of extraction. Index starts at 1. A negative number as the length means the remainder of the string.

Syntax

SUBSTR(<string>, <int index>, <int size>)

Also known as SUBSTRING.

Example

substr("Hello John", 7, 4) // "John"
substr("Hello John", 7, -1) // "John"
substr(null, 10, 10) // null