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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top