CALCFIRSTNAME$(string_exp$)

 

Returns a String Value
Returns a string consisting of characters copied from string_exp$ beginning at the start of the string to the first space, excluding any titles. Additionally, searches string_exp$ for a title, which is then prepended to the new string.

Titles:

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

Mr., Mr, Mrs., Mrs, Miss., Miss, Ms., Ms, Sir, Dr., Dr, Prof., or Prof

Examples:

CALCFIRSTNAME$("Mr. John Q. Public")

Returns "Mr. John”.

CALCFIRSTNAME$(NAME)

Returns "Michael" 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:	CALCMIDDLENAME( )
	CALCLASTNAME( )