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