Parse first mi last

[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

 

[RobFMS]

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

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