I need to remove the last name of a full name in a field

Discussion created by jcjordan on Feb 12, 2014
Latest reply on Feb 12, 2014 by jcjordan
I have a 'fullName' field in the table for example "ROBINSON GLENN K"  I want to remove the last name or "Robinson", basically all characters up to the space. Im guessing this would be better done with the python functions in field calculator rather than the VB script. can someone help me with which function to use and how? I need to do this for about 1000 attributes so manually doing this is not an option