Applies to: Databricks SQL Databricks Runtime
str around occurrences that match
regex and returns an array with a length of at most
str: A STRING expression to be split.
regexp: A STRING expression that is a Java regular expression used to split
limit: An optional INTEGER expression defaulting to 0 (no limit).
An ARRAY of STRING.
limit > 0: The resulting array’s length will not be more than limit, and the resulting array’s last entry will contain all input beyond the last matched
limit <= 0:
regex will be applied as many times as possible, and the resulting array can be of any size.