Splitting to columns with Regex_replace in Alteryx

Splitting to columns with Regex_replace in Alteryx

The text to columns tool in Alteryx can sometimes be a little clunky. It’s a quick fix when you need each element of ‘Element1/Element2/Element3’ to be in it’s own column, but what if the string was ‘Element1/    Element2_     Element3    ’? This requires multiple...
Quick and easy date parsing in Alteryx

Quick and easy date parsing in Alteryx

Dealing with time series is a huge part of data analytics. A date field that’s well formatted and consistent will typically transition seamlessly into whatever reporting tool you’re using. A date field that is consistent, but incorrectly formatted, can normally be...
How to learn RegEx (the painless way)

How to learn RegEx (the painless way)

If you suddenly need RegEx to solve a problem, it can be tempting to google a syntax list and start awkwardly crafting the pattern that will (hopefully) match whatever string you need.  This can be time consuming, however, and it’s likely that your solution is not the...