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
Name | DataType | List Options | Description |
---|---|---|---|
value | string | The source string to split | |
delimiter | string | The substring to split on | |
index | int | The substring to return (0 based). Use -1 to return the last item |