SubString

The Substring() function returns a subset of a text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text that is a subset of text beginning at a position through a number of characters. Returns Invalid expression if one of the parameters is not valid.

Syntax

Substring(text,length)

Substring("Important", 6) => "Import"

Substring(text,start_position,length)

Substring("Important", 2, 4) => "port"

Parameters

Name	Type	Required	Description
text	text	☑️	a text
start_position	numeric		(optional) the position to start from
length	numeric	☑️	the number of characters to take from text