Description
Return all occurrences of strings that match a regular expression in a bag.
Syntax
REGEX_FIND_ALL(string_expression, regex)
Arguments
string_expression - string expression
regex - string expression indicating a regular expression
Examples
REGEX_FIND_ALL('abcdefg','[a-d]')
returns a bag with the following items: a,b,c,d.
Return value datatype
Bag
Impact of null value
If string_expression is null, returns null. If regExp is null, an error is raised.