Interactive Lessons

Splitting values into multiple columns or rows doesn’t have to be a pain. The Text to Columns tool makes it almost too easy.

Regular Expressions are extremely powerful tools, but you don’t have to use a RegEx tool to harness that power.

Learn how regular expressions are a powerful parsing tool for string data.

Identify string data values that match a pattern defined by a regular expression.

Use regular expressions and marked groups to replace values in string data.

Split a block of string data into columns or rows based on a pattern in string data.

Separate string data values into columns using a regular expression and marked groups.

Parse and retrieve values from eXtensible Markup Language data.

Parse and retrieve values from JSON data.