It is not looking backward, reading from right to left, processing each character in the pattern as > followed by p followed by <. I added another possibility in my answer, I know it's not a beautiful solution, but it works. Position: Technical Architect, Supply Chain Applications (Remote)<br>Description<br><br>Molex is a global electronics leader committed to making the world a better, more-connected place. you can still use The following regular expression is similar to the previous one. It can take a while to get comfortable with the regular expression syntax for capture groups, lookaheads and lookbehinds. TL;DR: Can't do exactly that, but you can the 'e' option and use non-capturing groups with (?:re). I also overloaded the UDFs so that you can call them using minimal parameters or optional parameters the same as their base Snowflake functions. The problem solvers who create careers with code. Ypsilanti, Augusta, and Superior are nearby cities. English version of Russian proverb "The hedgehogs got pricked, cried, but continued to eat the cactus". backslash appears in a string literal, the backslash itself must also be escaped, so the query looks like: The following query makes it easier to see that the regular expression is composed of two characters (the backslash escape Patterns support the full POSIX ERE (Extended Regular Expression) syntax. For details, see the characters, see Specifying Regular Expressions in Single-Quoted String Constants. to get all matches. Use //# instead, TypeError: can't assign to property "x" on "y": not an object, TypeError: can't convert BigInt to number, TypeError: can't define property "x": "obj" is not extensible, TypeError: can't delete non-configurable array element, TypeError: can't redefine non-configurable property "x", TypeError: cannot use 'in' operator to search for 'x' in 'y', TypeError: invalid 'instanceof' operand 'x', TypeError: invalid Array.prototype.sort argument, TypeError: invalid assignment to const "x", TypeError: property "x" is non-configurable and can't be deleted, TypeError: Reduce of empty array with no initial value, TypeError: setting getter-only property "x", TypeError: X.prototype.y called on incompatible type, Warning: -file- is being assigned a //# sourceMappingURL, but already has one, Warning: unreachable code after return statement, ClassRanges in the ECMAScript specification. How to return only a single regex match group in snowflake? Snowflake supports regular expressions (regex) for string matching and replacements. /(?