Regexp function reference

regexp_count

Count the number of non-overlapping occurrences of a regular expression pattern in a string.

Example: regexp_count('abacad', 'a|b')

Output: 4

regexp_instr

Returns the starting position of the first match of a regular expression pattern in a string.

Example: regexp_instr('abcdef', 'cd')

Output: 3

regexp_like

Returns true if the string matches the regular expression pattern.

Example: regexp_like('cat dog house', 'dog')

Output: true

regexp_replace

Replace the first regular expression match in a string.

Example: regexp_replace('alphabet', '[ae]', 'DOG')

Output: DOGlphabet