This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Course Description: Sometimes using a text-to-columns or complex string functions can be burdensome, time-consuming, and difficult to disseminate. In this training, we will demonstrate how to build Regular Expressions (RegEx) in Alteryx, and the many ways to unlock its powerful and flexible parsing abilities.
You’ll Learn How to:
Use the Parse, Match, Replace, and Tokenize functions in the RegEx Tool
Write simple regular expressions
Leverage the formula tool to evaluate regular expressions
@Thomas_simonet , this is awesome! I am loving the RegEx to parse the journal name/reference/date. Nice work! Even more impressive: your patience to type that conditional statement in your Formula tool. ;-) Did you know that the DateTime tool allows you to use specifiers to create a custom format for an incoming string? I mean...it's not RegEx, but it's a nifty alternative method to create your output. I attached a workflow that demonstrates how I did it!