ETL: REGEX_FIND_ALL

Return all substrings matching a regular expression as a bag (array). Use REGEX_FIND_ALL for comprehensive pattern matching in ETL data pipelines.

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.