REGEXP_SPLIT
Splits a string by a regular expression pattern and returns an array of substrings.
Analyze Syntax
func.regexp_split('one1two2three', '[0-9]')
Analyze Examples
func.regexp_split('one1two2three', '[0-9]')
┌───────────────────────┐
│ ["one","two","three"] │
└───────────────────────┘
SQL Syntax
REGEXP_SPLIT(<str>, <pattern>)
SQL Examples
SELECT REGEXP_SPLIT('one1two2three', '[0-9]');
┌───────────────────────┐
│ ["one","two","three"] │
└───────────────────────┘