I have a CSV file that has a single column of full names that are in different formats. Some include suffixes and initials. There are thousands of records.
I want to break each record apart into separate columns for each part of the full name that exists. The final columns would be:
Title
First Name
Middle Name
Last Name
Suffix
Here is an example of what some of the different names look like:
John Smith
Doe, Jane, MBA
Mrs. Sarah Johnson
Steven P Little
Fredericks, J S, D.D.S.
S Morrison, Dr Oscar
Fred Jones, M.B.A.
T. H. Gallatin
Morris Jr, Gary B.
What is a good way to break those out into separate columns given there is no standard format to the full names?