REGEX_EXTRACT

Returns an array of all the regex matches on the input text.

Syntax 

REGEX_EXTRACT(text, regex)

Examples 

Example 1

Input

{
  "my_action": {
    "message": "The quick brown fox jumps over the lazy dog. It barked."
  }
}

Formula

REGEX_EXTRACT(my_action.message, "[A-Z]")

Output

[
  "T",
  "I"
]
Example 2

Input

{
  "description": "A more complex example that also extracts the first match and pipes it further to a down case function.",
  "my_action": {
    "message": "This is an automatically generated message from Tines"
  }
}

Formula

REGEX_EXTRACT(my_action.message, "(?<=This is)(.*)(?=generated)")[0][0] |> DOWNCASE(%)

Output

" an automatically "
Was this helpful?