Names into Parts

Description

Splits the value of a single name column into its component name parts.

When you apply this transformation, Monarch Data Prep Studio asks you which of the following name components are available:

1. • Prefix

   • First Name

   • Middle Name

   • Last Name

   • Last Name

   • Suffix

Monarch Data Prep Studio will do the name split depending on the components you selected on the dialog box.

 

INPUT/Output DATA TYPE

Input	Output
text	text

 

example

In the example below, Name is the original column, and the remaining three fields to the right are the result of the name split into First Name,  Middle Name, and Last Name.