Hi,
I have a database which has 70000 records with a "name" field which consists of first name and surname. Can anyone help me to split this up in two new fields "FirstName" and "Surname"?
Just to be able to do this would be good, but....to make it just that little bit easier, someone has entered Mr or Mrs and also single letter middle initials in some of the original fields.
any help would be greatly recieved,
thanks
Allen.
I have a database which has 70000 records with a "name" field which consists of first name and surname. Can anyone help me to split this up in two new fields "FirstName" and "Surname"?
Just to be able to do this would be good, but....to make it just that little bit easier, someone has entered Mr or Mrs and also single letter middle initials in some of the original fields.
any help would be greatly recieved,
thanks
Allen.