STRIPCOMPANYSUFFIX

Description

Removes all trailing punctuation and common words used at the end of company names such as; Inc, Incorporated, Corp, Corporation, Co, Company, Ltd, etc.

Syntax

STRIPCOMPANYSUFFIX ( TextSourceField )

Parameter	Description
TextSourceField	The string containing the company name.

Remarks

Use this function with the STARTSWITH operator in the Lookup Criteria window for better company matching.

See the table below for the list of suffixes that will be removed by the function.

Prefixes

Doctor

The

Suffixes

Agency	Gmbh	PA
and	Group	PC
Assn	Hotel	Pharmacy
Assoc	Hotels	PLC
Associates	Inc	PLLC
Association	Incorporated	Restaurant
Bank	International	SA
BV	Intl	Sales
Co	Limited	Service
Comp	LLC	Services
Company	LLP	Store
Corp	LP	Svcs
Corporation	Ltd	Travel
DMD	Manufacturing	Unlimited
Enterprises	Mfg

Examples

This function returns "The Joseph & Joseph":

STRIPCOMPANYSUFFIX("The Joseph & Joseph Corporation")

This function returns "TeleTronics":

STRIPCOMPANYSUFFIX("TeleTronics Co., Inc.")

How it Works

The STRIPCOMPANYSUFFIX function returns the root company name by removing trailing characters such as comma or period, and trailing words such as Inc or Corporation.

The function algorithm processes:

The string and removes the following trailing characters: comma, period, ampersand, apostrophe, dash or space.
The trailing word in the string and checks it against the company suffix list. The company suffix list is stored in the STRIPCOMPANY table with a value of S in the PARTTYPE column.
- If the trailing word is in the company suffix list, the word is removed from the string and the next word or character is checked.
- If the trailing word is not in the company suffix list or if the trailing character is not in the list above, then it stops checking the remaining words and returns the string in its current format.

The end result is a string with all trailing commas, periods, ampersands, apostrophes, dashes, spaces and company suffixes removed.