That could be a lot things causing that error. Since it looks like the names do not contain all three (first, middle, last), you need to account for those like Clint. You can do that with using a function. Make sure python is checked, and Show Codeblock is checked. If there are only two, like Clint, youll need to skip the middle name because Shugart is probably their last name. Indenting counts here, and can be a pain so make sure you use 4 spaces per indent if the code doesn't copy paste correctly.
def namesplit(name):
splt = name.split(' ')
if splt[0]:
return splt[0]
else:
return None
# and in the FirstName block:
namesplit(!Name!)
def namesplit(st_name):
splt = st_name.split(' ')
if len(splt) > 2:
if splt[1]:
return splt[1]
else:
return None
and last name code:
def namesplit(st_name):
splt = st_name.split(' ')
if len(splt) == 2:
if splt[1]:
return splt[1]
elif len(splt) > 2:
if splt[2]:
return splt[2:]
else:
return None
added return splt[2:] to capture the Sr, Jr, etc.