Database Tour Documentation
substr function

Category:

Miscellaneous

Returns the part of a string between the start index and a number of characters after it.

Syntax

substr(
  Str String,
  Index Integer,
  Count Integer
): String

Parameters

Str is the string to search.

Index is the position where to start the extraction. First character is at index 1.

Count is the number of characters to extract.

Return value

Type: String. If Index is greater than, or equal, to the length of the Str, the function returns an empty string.

Examples of using

substr(dataset_field_val(1, 'Address'), 1, 4)