You load a dataset from Microsoft Excel. The following is a sample of the data.
FullName contains student names. Some names contain a first name and a last name. Some names contain a first name, a middle name, and a last name.
You need to divide FullName into three separate fields: One for the first name, one for the middle name, and one for the last name. The solution must minimize effort.
What should you do?
To divide a full name into three separate fields (first name, middle name, and last name) efficiently, you should use the Custom Split option and specify a space as the delimiter. This allows for proper handling of names with different components, ensuring that each part of the name is correctly separated into its respective field.
Answer is correct. If you use just split it will divide full name into two columns, so if full name, for example, contains middle name, after just split the last name will be missing. That is why you need to use custom split indicating the number of splits and separator.