Extracting parts of a full name
You can use the Extract full name parts function to extract the different parts that make up a full name into different columns.
About this task
In this example, you have received a dataset containing information about the subscribers of your online service, such as their full names, or subscription date. However, you need to export this data to a CRM solution and the full name format is not ideal for this task. To match the expected format of your CRM, you would prefer to have each part of your customers names displayed in dedicated columns. In order to achieve this, you will simply apply the Extract full name parts function to the column containing the customers names.
Procedure
Results
Information noteTip: This transformation can also be performed by using the Automatically formatting data based on examples
function.