Clay formula
Clean company legal suffixes
Strips Inc, LLC, Ltd, GmbH and punctuation so company names match across sources.
Columns it needs
Company
The snippet
REGEX_REPLACE(TRIM({{Company}}), "(?i)[,.]?\\s*(inc|llc|l\\.l\\.c|ltd|limited|gmbh|b\\.v|s\\.a|pty|co)\\.?$", "")How to use it
- 1Add a formula column named Company (clean).
- 2Paste the expression and map {{Company}} to your raw company column.
- 3Use this cleaned column as the dedupe key instead of the raw name.
cleanupdedupecompany