CALCMIDDLENAME$(string_exp$)

 

Returns a String Value
Returns a string consisting of characters copied from string_exp$ beginning at the first space of the string to the last space of the string, excluding any titles or suffixes.

Examples:

CALCMIDDLENAME$("Dr. William W. Henrey")

Returns "W.”.

CALCMIDDLENAME$(NAME)

Returns "Ann" if the Full Name of the contact is “Kelly Ann White”.

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( )
	CALCLASTNAME( )