Parses the title (e.g. Mr. Mrs. etc) into the specified field to be updated.
- Designed to break a field containing a full name into Salutation, First, Last, and custom suffix name fields
- Includes logic to identify titles, suffixes, first initials, hyphenated last names, 2 word last names etc.
- Input "Dr. Smith" will parse "Dr." as the salutation and "Smith" as the last name
- Input "Mary-Anne Smith" will parse "Mary-Anne" as the first name and "Smith" as the last name
- Input "Oscar de la Renta" will parse "Oscar" as the first name and "de la Renta" as the last name
- Input "Mrs. Laurie A. Smith DDS" will parse "Mrs." as the salutation, "Laurie A." as the first name, "Smith" as the last name, and "DDS" as the suffix
Click HERE to return to the full list of MassImpact Formulas.