substring_index
function
Applies to: Databricks SQL
Databricks Runtime
Returns the substring of expr
before count
occurrences of the delimiter delim
.
Arguments
expr
: A STRING or BINARY expression.delim
: An expression matching the type ofexpr
specifying the delimiter.count
: An INTEGER expression to count the delimiters.