Exam TDA-C01 topic 1 question 84 discussion

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?