Hello,
I need to extract the middle initial from a name field that contains the last name, comma, and the middle name or initial. There is no space after the comma and, in some cases, there is a space in the last name.
Example data:
Smith,Jane Ron
Dow,John L
Ali Welsh,Mary Jane
The result I am looking for is to capture the first letter of the middle name. In this data example, I would need to capture the following on a separate column:
R
L
J
Any help will be greatly appreciated.
rb
I need to extract the middle initial from a name field that contains the last name, comma, and the middle name or initial. There is no space after the comma and, in some cases, there is a space in the last name.
Example data:
Smith,Jane Ron
Dow,John L
Ali Welsh,Mary Jane
The result I am looking for is to capture the first letter of the middle name. In this data example, I would need to capture the following on a separate column:
R
L
J
Any help will be greatly appreciated.
rb