Try Opteryx

SPLIT

Splits a string into an array using the specified delimiter.

Category: String Functions

Syntax

SPLIT(string, delimiter)
SPLIT(string, delimiter, limit)

Arguments

  • string varchar String input value.
  • delimiter varchar Separator used to split the input string.
  • limit integer Maximum number of items or splits to return.

Returns

ARRAY — Returns the computed result as ARRAY<VARIANT>.