CALCLASTNAME$(string_exp$)

 

Returns a String Value
Returns a string consisting of characters copied from string_exp$ beginning at the last space of the string to the end of the string, excluding any suffixes. Additionally, searches string_exp$ for a suffix, which is then appended to the new string.

Suffixes:

The following suffixes are detected in the string_exp$ and, if found, are appended to the new string.

Jr., Jr, Junior, Sr., Sr, Senior, Esq., Esq, Esquire, I, 1st, II, 2nd, III, or 3rd

Examples:

CALCLASTNAME$("John Q. Public Jr.")

Returns "Public Jr.”.

CALCLASTNAME$(NAME)

Returns "Jensen" if the Full Name of the contact is “Michael L. Jensen”.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)

 

See also:	CALCFIRSTNAME( )
	CALCMIDDLENAME( )