Parse first mi last

  • Thread starter Thread starter Michael San Filippo
  • Start date Start date
M

Michael San Filippo

Anyone have a function that does name parsing.

For example
I have all in 1 field First MI Last - sometimes no middle

need to break into 3 fields. using a blank for ones that dont have middle.

any ideas?

Thanks,
Michael
 
There is the Split() function in VBA (2000 and up), as long as the names are
in the appropriate ordering (last first middle). Use the space character as
the delimiter.

See the help file for more details

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

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

Name Parsing 1
Parsing inconsistent data 6
Parsing Names 6
Parsing Text 1
Sometimes there a middle initial 5
NotInList w/ Form 2
Using VBA, How Can I Replace A Character In A Field? 4
Parsing Question 4

Back
Top