SWAPNAME$(string_exp$)

Returns a String Value
Returns the string that reverses the format used for Contact fields. This function is used when you want the value of a contact's name using only the Contact ID.

Examples:

SWAPNAME$(CLIENT_ID:NAME)

Returns "Joseph M. Lewis" assuming the Client Name field in the Client file is "Lewis/Joseph M.".

Note: When the Contact ID does not contain a slash, the string is returned without any changes.

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)