REGEXPARSE

The REGEXPARSE function breaks a text based on regular expression into its capture groups, delimiting them using the provided delimiter.

Syntax:
REGEXPARSE ( single-text-expression, single-text-expression, single-text-expression )
Meaning:
REGEXPARSE ( input_text, regular_expression, delimiter )
Returns:
A single text item

Examples

  • REGEXPARSE("44034AAA", "^(44)([0-9]|[aAbBcC])\s*([0-9]{2})\s?(?:[A-Z]{3})$", "|")

    Returns: 44|0|34

  • REGEXPARSE("1011XYZ", "^(10)([0-9]|[aAbBcC])\s*([0-9]{1})\s?(?:[A-Z]{3})$", ".")

    Returns: 10.1.1