REGEXP_INSTR

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the position of the first substring matching a regular expression pattern.

  • <string>: The string to search within.
  • <pattern>: The regular expression pattern to find.

Returns an integer representing the one-based position of the match, or 0 if no match is found.

Find the position of digits in a string.

Returns 4, the position where digits begin.

Returns 0 when pattern is not found.

Returns 0.

Find the position of a word pattern.

Returns 11.

Filter rows based on pattern position.

Returns products where code starts with two uppercase letters.