Issue with Normalizing Company Names: Limited Removal

The "Normalize Company Name" feature in Clay is designed to remove common suffixes like "Inc," "LLC," and other corporate designators from company names. However, it appears that "Limited" might not be included in the list of suffixes that are automatically removed. To address this, you can try these steps: 1. Use the "Normalize Company Name" function as usual. 2. Enable the "Normalize Case" option if the company names are in all uppercase or lowercase. 3. If "Limited" is still present, you might need to use an additional cleaning step or an AI formula for more complex cases. If you need further assistance with this specific issue, please request human support by clicking on "Talk to a person" in this chat.

Sources: Normalize Company Name with Clay Formatters Clay formatters overview | Documentation | Clay University Data Cleaning + Normalization [Clay 101] - Clay University

Hi Spencer, thank you for reaching out. If you wish to remove "Limited" you should use a formula column where you tell it what words you would like to remove if present in the company name.

One free way to carry out this task, is through the use of " Formulas" enrichment. In order to add a formula column, select "Add Column" and then from the drop-down menu select formulas, as shown below:

After selecting this, you'll be able to either use an AI prompt in the first box or JavaScript to instruct Clay on how to process the results from a column. An example of what this looks like is shown below:

In this case, I recommend using the first box to specify what you want Clay to do. Then, click on "Generate Formula," which will create a JavaScript formula for you and show the results that would be generated if the formula were applied. If you're satisfied with the results, simply click "Output Is Correct, Save Formula." The button is shown below:

For more information on how AI formulas work, I recommend you take a look at this Clay University video, which explains everything in more detail! Please let me know if this helps!