Recalculating an alpha field value based on special characters (Last Name)

[ldalessio]

Good Morning -
I would like to recalculate a double last name field to return a new value based on special characters and spaces.
For example: Diaz-Garcia would return Diaz, Abel Smith would return Abel. Not sure how to go about this.
Thank you for all the help.

 

[Charliy]

if '-' in {table.lastname}
then split({table.lastname},'-')[1]
else {table.lastname}

 

[BettyJ]

To get Abel from Abel Smith in your example, add space too in the formula suggested by Charliy,

[tt]if '-' in {table.lastname}
then split({table.lastname},'-')[1]
else if ' ' in {table.lastname}
then split({table.lastname},' ')[1]
else {table.lastname}[/tt]

 

[ldalessio]

Thank you everyone. As always, you guys are terrific!