View on GitHub

JODA - JSON On Demand Analysis

Efficient data wrangling for semi-structured JSON documents

SPLIT - String

Splits a given string by the supplied delimiter

Input parameters

Name Type Optional Description
str String False String to split
delimiter String False Delimiter to split by

Output

Array[String]: The split strings

Usage

SPLIT(<str>, <delimiter>)

Examples

Example 1

Query

LOAD tmp
AS ('': SPLIT("Hello World", " "))

Result

["Hello","World"]

Example 2

Query

LOAD tmp
AS ('': SPLIT("5>=4>=2", ">="))

Result

["5","4","2"]