Access to split First and Last name

S

SvenAke

Joined
Oct 15, 2012
Messages
2
Reaction score
0
I have imported name lists (about 200 000 names ) from several Excel DBF-files. For some reason the table 'Name' column were mixed up, all the names looked like this
' sometext(AndersSvensson)' without spaces. The names are only First and Last name.
I have managed (by SQL) to extract the name but how to insert a space before the last Ucase letter as Anders Svensson.
I can't figure out how to split the name into First name and Last name or insert a space.
Asc (string) only points at the first Ucase letter. I cant find a solution to highlight the last Ucase letter.
Any help would be appriciated. Can it be done through SQL?

Looking forward to the reply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access SQL to split a name 1
Switch Last Name First Name to First Name Last Name 2
Split the contents of a field ie - full name into first and last n 3
Split CustomerName into First and Last 2
Seperate First Name and Last Name 3
Merging First and Last Name fields 13
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
delete spaces between last name and first name 2

Top