Regular Expressions in Alteryx

Contents

Why Should I Learn Regex?

Most of the data we deal with day-to-day is text. And so the ability to manipulate text is an important tool for any data analyst. Fortunately, regular expressions – often referred as the portmanteau regex – are an incredibly powerful way of controlling your string fields. So much so in fact, that it often feels like cheating. It’s useful for parsing, extracting, scraping, cleaning and even feature engineering. For example,

[show example of getting domain name from email addresses]

This guide walks you through all the regex you’ll need to be text parsing powerhouse. Although this focuses on using regex within Alteryx, the other benefit to learning this is that it’s applicable everywhere – including all main programming languages, serious text editors and BI tools.