Here we are, starting with regular expressions In my eyes it’s one of the most complex topics in SQL alongside window functions. As with any complexity, once it is mastered it gives you so much power.
I use regular expressions daily to match complex text patterns for many purposes. I think that regular expressions are one of the most important tools of any Data Analyst. Let’s get it!
What are regular expressions?
Regular expressions (also known as regex or regexp) is a way to define search patterns in text. That’s it. It sounds simple but I...