DSXchange

Hi,
Can somebody provide me code to seperate first name and middle initial.
Currently they are in the same field.Some examples are as follows

Cari A
Michael A C
Leslie Marc
Kuan-Yu
Cielo Patricia
Renee (Johnson) M
Gary D Sr
It should be like first name:cari
middle initial:A
First name:cielo
middle initial:p
Thanx in advance.

What would be the Middle name in case of

Michael A C
Leslie Marc
Kuan-Yu
Renee (Johnson) M
Gary D Sr ?

What is the metadata of your Middle name. CHAR(1)? If you can play around with CAPITALS built in transform and the Field Function you might be get near to it.

Kris
If the name is:Michael A C
Then first name will be Michael
Middle initials will be A C
if the name is :Leslie Marc
Then first name will be Leslie
Middle initials will be M.
Thanx

Assuming that you want everything ahead of the first space character, and everything after the first space character, then the Field() function is what you need.