How to split First and Last Name in the same field

I have imported a database from Excel where First and Last name are in the same field.
I would like to split the First and the Last Name in 2 different fields First Name and Last Name.
Does somebody know a script able to do that for all my records quickly ?
Thanks
hainauxAsked:
Who is Participating?
 
lesouefConnect With a Mentor Commented:
Use extraction functions.
Only people with composite names is a problem.
So strip the names as follows:
First word to surname, rest to firstname.
Hopefully the composite name have hyphens (-). If not, the 2nd name may be put to firstname...
So better check manually for people having more than 2 words in the original name.
Do this after import using the replace function. Do not delete the original field untill sure about name stripping has been checked ok.
It should look like:
Display all records
replace (surname ; motsdebut (original name ; 1))
replace (firstname; motsextrait (original name ; 2; nombre de mots (original name)-1)
create a field "size" = nombre de mots (original size)
search those where size > 2
check for any weird firstname.

0
 
hainauxAuthor Commented:
Everything has been ok.
The only thing is : How to stop a script within a 'boucle' when the last record is reached.
Boucle
zczc
zxcvzcv
zxcvzv
fin de boucle
Each time I have to stop with Escape button and modify the last record
0
 
lesouefCommented:
there is a setting (checkbox at the bottom of the window when you click on record next (exit script after last = fin de script après dernière).
0
 
hainauxAuthor Commented:
ok thank you very much
0
 
AkostechCommented:
how can this be done programatically with tsql??
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.