Skip to main content

REGEXP_INSTR function

Returns the position of the first substring in str that matches pattern

Note

CeloSQL uses Java regex patterns.

Syntax

REGEXP_INSTR( str, pattern )

Arguments

  • str: A VARCHAR expression to be matched

  • pattern: A VARCHAR literal with a regular expression pattern.

Returns

A BIGINT

Examples

> SELECT regexp_instr('VEND - 1234567 WILLY WONKA', '(\d+)');
8

> SELECT regexp_instr('hello world', 'goodbye.*');
0