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