Substring() mvSQL database function in Jitterbit App Builder¶
Summary¶
Pulls out a part of a string based on position in the string and number of characters to take from the string.
Syntax¶
SUBSTRING(<string>, <position>, <length>)
Parameters¶
string¶
The string to evaluate.
position¶
The substring start position.
length¶
The desired length of the substring.
Returns¶
A substring given the parameters.
Examples¶
SUBSTRING('ABCDEF', 3, 2)
Returns
CD