Is there a way to auto-populate a field based on the first word in another field?
I am trying to figure out if there is a way to do a massive auto-populate of a field titled "GUARDIAN ONE FIRST NAME" based on the first word in the field, "GUARDIAN ONE NAME". Is there a way to do this?