Unanswered: Adding periods after MI in db that has some MI and periods to start
I'm trying to clean up a database that has middle initials in a field MI, but only a third of the records have a period after the MI.
I thought of going through letter by letter and doing something like this
I tried that and if the letter has a period it ignores it and adds a period, so I have to do two steps, going back and replacing the two period letters. Not the end of the world, just checking to see if anyone has a better way of doing it maybe with a loop of the alphabet. (or two loops based on my results).