Formula: Strip Suffixes from Name
Thomas_937381
Posts: 196
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:
0