REGEXPOSITION

The REGEXPOSITION function returns the first position of a match of the regular expression in the text.

Syntax:
REGEXPOSITION ( single-text-expression, single-text-expression )
Meaning:
REGEXPOSITION ( input_text, regular_expression )
Returns:
A single integer

Examples

  • REGEXPOSITION("ABC6EF", "([\d]+)")

    Returns: 4

  • REGEXPOSITION("1234A3456", "([A-Z]+)")

    Returns: 5