If you've ever wished Excel could handle text patterns the way Python or JavaScript does, these functions deliver exactly ...

Regular expressions have been part of the programmer’s toolkit for a long time, with their creation by Stephen Cole King in 1951. Their ability to match word patterns make them a powerful tool for ...

Some say a set of regular expressions comprises a domain-specific language, or DSL; essentially, a mini-programming language. A full-blown programming language like Java or Python can do many things, ...

Recently Microsoft has introduced a game-changing set of functions in it’s Excel spreadsheet software that harness the power of Regular Expressions (REGEX) to streamline data extraction, cleaning, and ...

Microsoft Excel has recently introduced three powerful new functions that leverage regular expressions (REGEX) to enhance text manipulation capabilities. These functions simplify tasks that were ...

This article explains what regex (or regular expressions) is and how to get started using it with web crawlers, plus some interesting real-world use cases. One technology skill that is too-often ...

If you work with strings in your Python scripts and you're writing obscure logic to process them, then you need to look into ...

You know the maxim, “Give a man to fish and he eats for a day; teach a man to fish and he eats for a lifetime”? A similar adage applies to anyone who spends a lot of time working with text on their ...

The people who attended my presentations at RMOUG Training Days 2010 asked several good questions. One question that was asked in the Groovy presentation that I really wish I had included a slide on ...