Formula: Strip Suffixes from Name

Options
Thomas_937381
Thomas_937381 Posts: 196
in Show and Tell

Try using this snippet in a Fields: Field formulas action to remove II, III, IV, Jr(.), and Sr(.) suffixes from a name.

result = fields['name'].replace(/\s(II)/g,'').replace(/\s(III)/g,'').replace(/\s(IV)/g,'').replace(/\s(Jr.)/g,'').replace(/\s(Jr)/g,'').replace(/\s(Sr.)/g,'').replace(/\s(Sr)/g,'')

Tagged:

Categories