At ArcGIS 10.8.1, I have a shapefile attribute table containing a text field with names ordered last, first, middle, as in this example:
Smith Sally J
Jones William Randolph
I need to reorder the names so that they are listed as first, middle, last:
Sally J Smith
William Randolph Jones
I think that moving the first text string (i.e. the last name) to the end would solve the problem.
I've attempted to reorder the names into a second, empty text field using the Field Calculator, without success. In particular, I've looked into the Python .split() function, but am stymied with how to move the first text string to the end.