How to split last, first and middle name from Name field?
Posted on 2003-11-03
In my table I have a field called "Name" and the field look like this:
Lamphere, Justin C
Vazquez Cortez, Fernando
Thompson, Chennea S
Is it possible to separate them and create 3 columns, one for last, one for first and the other for middle name.
The output table will look like this:
Name last first middle
Lamphere, Justin C Lamphere Justin C
Vazquez Cortez, Fernando Vazquez Cortez Fernando
Thompson, Chennea S Thompson Chennea S
Her, Mai Her Mai
I there a way to separate this field to 3 columns above. Thanks.