Answers.Body: <p>I happen to have written an extension called the "<a href="https://civicrm.org/extensions/organisation-name-de-duplicator" rel="nofollow">organisation name de-duplicator</a>". It works by doing certain REPLACE()ments on the names and seeing which ones come out the same. It hasn't had much attention for a while but more rules could be added.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-23T00:36:02.537Z
Answers.LastActivityDate: 2015-12-23T00:36:02.537Z
Answers.UserDisplayName: DaveFF
Body: <p>Dedupe rules are cool, and works well for Individuals, primarily because you have multiple fields to combine.</p>
  
  <p>When it comes to organisations it is more difficult. We focus on individuals but want to register the organisations they work for, so in the profile we use for most on-line registrations (events, subscriptions, ...) we ask for organisation name.</p>
  
  <p>This often leads to multiple organisation records with almost the same name. Typical name variations are</p>
  
  <ul>
  <li>Somecompany Inc.</li>
  <li>Somecompany International</li>
  <li>Somecompany</li>
  </ul>
  
  <p>Dedupe rules are of limited help here since the best I can do AFAIK is the length of the match.</p>
  
  <p>In Sweden a <em>very</em> common pattern is</p>
  
  <ul>
  <li>Ericsson</li>
  <li>Ericsson AB</li>
  </ul>
  
  <p>I would be extremely happy if there was a way to match the full length except for the last three characters... Or if the match was true if the shorter is a true substring of the longer. Documentation is kind of flakey here, it doesn't say anything about what happens when fields are of different lengths.</p>
  
  <p>Another alternative would be to match to either to the organisation name or the legal name. This would handle most of the above cases and allow me to use the names as (I suppose) they where ment to be used, causal name vs. official/legal/full name.</p>
  
  <p>Actually I have a hard time figuring out how to make the best use the 'length' part of dedupe rules. (I'm a regex guy, so I'm longing for a LIKE-like option, is there one?)</p>
  
  <p>Any suggestions?</p>
  
Tags: <duplicate-contacts>
Title: Deduping organizations
ThreadText: # Deduping organizations
  
  (Asked by: username_0 on 2015-12-18)
  
  Dedupe rules are cool, and works well for Individuals, primarily because you have multiple fields to combine.
  
  When it comes to organisations it is more difficult. We focus on individuals but want to register the organisations they work for, so in the profile we use for most on-line registrations (events, subscriptions, ...) we ask for organisation name.
  
  This often leads to multiple organisation records with almost the same name. Typical name variations are
  
  * Somecompany Inc.
  * Somecompany International
  * Somecompany
  
  Dedupe rules are of limited help here since the best I can do AFAIK is the length of the match.
  
  In Sweden a *very* common pattern is
  
  * Ericsson
  * Ericsson AB
  
  I would be extremely happy if there was a way to match the full length except for the last three characters... Or if the match was true if the shorter is a true substring of the longer. Documentation is kind of flakey here, it doesn't say anything about what happens when fields are of different lengths.
  
  Another alternative would be to match to either to the organisation name or the legal name. This would handle most of the above cases and allow me to use the names as (I suppose) they where ment to be used, causal name vs. official/legal/full name.
  
  Actually I have a hard time figuring out how to make the best use the 'length' part of dedupe rules. (I'm a regex guy, so I'm longing for a LIKE-like option, is there one?)
  
  Any suggestions?
  
  **Tags:** duplicate-contacts
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-12-23. Score: 3
  
  I happen to have written an extension called the "[organisation name de-duplicator](https://civicrm.org/extensions/organisation-name-de-duplicator)". It works by doing certain REPLACE()ments on the names and seeing which ones come out the same. It hasn't had much attention for a while but more rules could be added.
  
  
  ---
  
  