Parsing Data Overview

You can parse data to identify logical elements in one input column and write these elements to multiple output columns.

Parsing data allows you to have greater control over the data quality of individual logical elements within data. For example, consider a data field that contains a person's full name, Bob Smith. You can use the Parser transformation to split the full name into separate data columns containing the first name and the last name. After you parse the data into separate logical elements, you can create custom data quality operations for each element.

You can configure the Parser transformation to use token sets to parse data columns into component strings. A token set identifies logical elements within data, such as words, ZIP codes, phone numbers, and Social Security numbers.

You can also use the Parser transformation to parse data that matches reference table entries or custom regular expressions that you enter.