Interactive Lessons

Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.

Also available in | Français | Português | Español | 日本語

Splitting Data with RegEx

Back to Lessons Feedback
AYXAcademy
Alteryx
Alteryx
Created

 

Lesson Objective: Split a block of string data into columns or rows based on a pattern. 

Estimated Time: ~7 Minutes

Description:  

  • Define a pattern found in string data using a regular expression. 
  • Use the Tokenize Output method in the RegEx tool to split data into rows or columns
  • Leverage a single marked group to output a subset of string data within a defined token.  

Recommended Follow-Up Training: Parsing with RegEx, Separating Data into Columns and Rows

Software Version: 2019.2

 

This lesson is also available in: PortugueseFrenchSpanishJapanese