I have a database where I need to import data from an excel file.
What my employer needs me to do is upon appending the data to a table which I named properties, under the field which I called owner, all the names should follow the correct format. Most of the inputted data does not follow the correct format.
The correct format of the names should be:
K. CURTIZ -> Where K is the initial of the First Name, it should have the '.' and a space before the Family Name
Here's an example of a data that is inputted incorrectly:
R OTTESON -> it should be R. OTTESON
another example where there are 2 names of 2 different persons, it should be inputted this way:
A. & J. PANAG
Mostly inputted incorrectly this way:
J&T BOTIFAN -> it should be J. & T. BOTIFAN
I hope somebody can help me with this.