Parse

The Parse category includes tools that separate data values into a standard table schema.

DateTime Tool: The Date Time tool standardizes and formats date and time data so that it can be used in expressions and functions from the Formula or Filter tool.

RegEx Tool: The Regular Expression tool uses regular expression syntax to parse, match, or replace data.

Text To Columns Tool: The Text to Columns tool takes the text in one column and splits the string value into separate, multiple fields based on a single or multiple delimiters.

XML Parse Tool: The XML Parse tool reads in a chunk of Extensible Markup Language and parses it into individual fields.