split

Description

Splits the string into an array, based on the separator.

Return type

array

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

split(value, separator)

Argument

Type

Optional

Repeatable

Restrictions

value

string

no

no

none

separator

string

no

no

constant

Examples

make_col date_parts:split("2024-04-05", "-")

This splits the given string by dashes, returning a JSON array of the elements: ["2024", "04", "05"].