Hyphenated Surname as One Word
I have a field called Individual, which has the full name of the person, e.g. Smith, John Henry. I made a filter field for the comma and the calculation to get the first names. Below is the right words calculation for the first name or names, which works perfectly. However, for the surname field, which is done by this calculation: LeftWords (Saint John Residents::Individual ; 1 ), I can't get a hyphenated surname, e.g. Smith-Jones. What appears is Smith.
Right words calculation: