Access Access SQL to split a name

Joined
Oct 15, 2012
Messages
2
Reaction score
0
I have imported a name list (about 200 000 names ) from an Excel DFB-file. For some reason the the first and last name are put together without space like 'AndersSvensson'.
They are all like that.
I can't figure out how to split the name into First name and Last name or insert a space.
Can it be done through SQL?

Looking forward to the reply.
 
Joined
Oct 23, 2012
Messages
29
Reaction score
0
if the Second name always start with capital letter then you can do it , i know how to do it through excel vba
if you know how to read from cell then good, if you don't then please review this post of me
https://www.pcreview.co.uk/forums/excel-vba-help-t4053800.html
i have explained how to read cells and write them to another excel sheet

now you'll have to do this

dim nStringCounter as integer
dim szString,szNewString as string
nStringCounter =1 'To Start From index 1 and skip first capital letter
szString =Sheet1.Cells(nRowCounter,nColumnCounter)szNewString=""
While nStringCounter <= len(szString) -1
if ASC(UCase(Mid(szString,nStringCounter,1)))=ASC(Mid(szString,nStringCounter,1)) then
szNewString= szNewString & "/" & Mid(szString,nStringCounter,1)
else
szNewString= szNewString & Mid(szString,nStringCounter,1)
End if
nStringCounter=nStringCounter+1
Wend
 

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

Top