Parse first name & surname from Windows logon name (Environ("UserName")

I was wondering if it would be possible to parse out an individuals first name & surname from their Windows logon name.

Obtaining the Windows logon name is easily done (

Please Login or Register  to view this content.

) so the only real difficulty is:

1. Correctly parse names from as many variations of a user name as possible (i.e. names separated with a full stop, names separated with an underscore etcetcera) and
2. Ignore most standard non-individual names (e.g. Administrator, Admin, Accounts, Sales etcetcera)

A quick google search throws up many results on parsing names from cells but these don't have a good success rate on actual user name formats. Below is what I have so far.

Please Login or Register  to view this content.

I think you've set yourself a task there..

Part of the solution may be to count the number of words in the name as a first step... You could modify the function to include seperators..

Please Login or Register  to view this content.

Originally Posted by AndyLitch

I think you've set yourself a task there..

True. I enjoy the challenge though.

Originally Posted by AndyLitch

Part of the solution may be to count the number of words in the name as a first step... You could modify the function to include seperators..

Thank you for the suggestion. I'm looking into it now. (I'm trying to think of a solution to handle when the first and last name don't have a separator. e.g. JohnSmith )

I am now up to this (see code below). It's not perfect. If you try it and your user name is not parsed by the function, I would be interested in knowing what it is so I can tweak it further.

Please Login or Register  to view this content.

if the users are on an active directory domain you could just query the domain controller for the user name

Originally Posted by JosephP

if the users are on an active directory domain you could just query the domain controller for the user name

Appreciate the suggestion. However I want this function as versatile as possible - work on non-networked PCs for e.g.