Skip to main content

SPLIT

Split a string into components using a delimiter

Example Usage​

SPLIT("ABC-123", "-", -1) -> "123"
SPLIT("123", "-", -1) -> "123"

Overview​

Function signature
SPLIT(value, delimiter, index)

Category
String

Return data type
string

Arguments​

NameDataTypeList Options                          Description
valuestringThe source string to split
delimiterstringThe substring to split on
indexintThe substring to return (0 based). Use -1 to return the last item