The Split matrix is for splitting columns into various parts. 

For example, a person's full name can be split into title, firstname and surname. Addresses are split into 15 separate elements such as Street Suffix, Street Name, Street Number, etc. Email addresses can be split into domain, sub domains, country etc. Telephone numbers can be split into international code, country and much more. It does this by using advanced algorithms to copy parts into new fields.

In fact, this Split matrix contains two incredibly powerful components for splitting Address & Person Name.


See below for an example of how it works. In this example the Person Name has been selected for column "ContactName".

Immediately, the 7 additional columns have been created on the Data Preview window (highlighted below). Clicking Run Clean will perform this process on the entire data table.



Click any of the following Split matrix options to learn more:


Person Name

Address

City/State/ZIP

Name & Email

Email

Check Email

Telephone

Date Time

Words