CONTENTS
Split names
Use the Split names step to split a full name value into smaller parts (first, middle, last, etc.).
Input/output
Your input data should consist of a column of full names.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac1b_Screenshot%202024-03-29%20at%202.38.49%20PM.png)
Your output will have multiple new columns of your names, separated into their parts, depending on the parts of the name you chose to split.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac1f_Results.png)
Custom settings
First, select the column that has the names you'd like to split by selecting it in the Column to Parse dropdown.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac1d_Which%20column%20Name_.png)
Next, pick the category that you want your full names broken down into by selecting them in the Choose Parts of Name dropdown.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac1a_Total%20columns.png)
You can select multiple parts in this dropdown, including Salutation, First Name, Middle Name, Last Name, Suffix, and Full Name.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac24_Additional%20columns.png)
If you select a part that does not exist in a name, the row's column will appear blank.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac1c_Middle%20Name%20blank.png)
Helpful tips
- Names ending in a comma may not be parsed.
- Names such as "Mister" may be parsed as the salutation, as opposed to the name.
Contents