> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.