# normcomp

## norm(source)

Normalize a string by:

1. trimming white space from each end
2. changing all multiple internal white space into a single space
3. removing all punctuation
4. lower casing all other characters
5. removing all company style "noise words" such as "llc", "ltd", "gmbh"

## Arguments

Argument | Data Type | Description
--- | --- | ---
Source | String | String to normalize

## Returns

The normalized string.

## Description

This function is used to convert a company to a more common format. The most common use for it is when matching between a source and target record; particularly when using standard matching or fuzzy matching.

For example, if you are using the Company name field to match with the target, you would find that "InaPlex Limited" does not match "Inaplex ltd" - note the difference in capitalization of the "P".

Using the normcomp() function would trim white space and map the string to lower case, so you would get a match.

## Example

Example | Returns | Description
--- | --- | ---
normcomp("Inaplex Limited") | "inaplex" | Normalize the company name to equalize internal spaces,lower case it, and remove "limited"

## See Also

norm()