v.21.6New Feature

Add splitByRegexp function

Add function splitByRegexp. #24077 (abel-cheng).
Introduces a new function splitByRegexp that splits a string into an array based on a regular expression delimiter.

Why it matters

This feature enables users to split strings more flexibly using regular expressions as separators, allowing complex and pattern-based string splitting instead of simple fixed delimiters. It enhances string processing capabilities within queries.

How to use it

Use the function by calling splitByRegexp(string, regexp), where string is the input text and regexp is the regular expression pattern used as a delimiter. This returns an array of substrings split according to the regex pattern.