How to use the regular expression functions provided by the ‘re’ library to match, search, and replace text in your Python programs.

Yes, regular expressions have been part of VBA for a while now, but the new functions allow you to use regexes right in the spreadsheet grid. There are plenty of caveats, of course.

Working with regular expressions I’m also going to cover how to work with regular expressions in JavaScript, though the concepts learned here apply to other languages as well.

This chapter’s first section introduces and explains all the key regular expression concepts and shows pure regular expression syntax—it makes minimal reference to Python itself. Then the second ...