STR_SUBSTR

Returns a substring with a designated number of characters starting at a specified point within a string.

Format

STR_SUBSTR (Input String, Starting Position, Length)

Arguments

 
Input String
Text string.
Starting Position
Integer value that determines the starting point of the substring.
Length
Integer value that designates the number of characters in the substring.

Examples

The following function returns a substring of the input string:
 
Function
STR_SUBSTR ("This is one string", 9, 8)
Result
one stri
The following example shows that the Starting Position and Length arguments can have any value and not cause errors:
 
Function
STR_SUBSTR ("This is a string", -1000, 100)
Result
returns the original string, since the values are out of range