Problem from a friend - not sure version of Oracle, probably old:
Oracle table with 1 column for First Name + Middle Initial (sometimes).
As part of an export process, they want to separate it out into two columns. This will be done about once per month. Volume is low (in the hundreds) so performance is not a consideration.
A "Middle Initial" can be defined as:
1 character grouping at the end of the column value sometimes followed by a dot but always preceded by 1 or more spaces and 1 or more groupings of characters (presumably the First Name).
What advice for methods for him to use? Thanks so much.