Press "Enter" to skip to content

Extracting Multiple Substrings with REGEXP_MATCHES

Koen Verbeeck wants to catch them all:

We have a use case where we need to extract a substring of a text. In addition, it needs to match a regular expression (regex). It’s also possible there are multiple matches in one piece of text. How can we efficiently extract those substrings without using a loop or a cursor?

Read on to see how this works.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.