SPLIT
Learn how to use the SPLIT string function in PlaidCloud Lakehouse. Splits a string by a delimiter and returns an array - see syntax, examples, and output.
Splits a string by a delimiter and returns an array.
Analyze Syntax
func.split(<str>, <delimiter>)
Analyze Examples
func.split('a,b,c', ',')
┌───────────────┐
│ ['a','b','c'] │
└───────────────┘
SQL Syntax
SPLIT(<str>, <delimiter>)
SQL Examples
SELECT SPLIT('a,b,c', ',');
┌───────────────┐
│ ["a","b","c"] │
└───────────────┘