Sub Text | TEXT_SUB

Syntax

TEXT_SUB( [value], [from], [length] )

Parameters

value
The TEXT value

from
An INTEGER that is starting index of the VALUE for the returned TEXT.

length
The number of characters in the returned TEXT.

Return Value

A new TEXT value that is a portion of the provided VALUE.

Description

Get a portion of a TEXT value.

Examples

TEXT_SUB() # returns ""

TEXT_SUB("text") # returns "text"

TEXT_SUB("Some text", 5) # returns "text"

TEXT_SUB("Some text", 5, 2) # returns "te"

TEXT_SUB(123456, 1, 3) # returns "234"