I need to match two sets of strings that slightly differ from each other.
This is my data class:
public class AccountPair
{
public string AccountNameA { get; set; }
public string AccountNameB { get; set; }
public int AccountNameB_ID {get; set;}
}
As a sample, AccountNameA is John Doe Ltd and AccountNameB is John Doe (PTY) Limited.
Using C#, I need to determine if AccountNameA is a match with AccountNameB and then output AccountNameA with the matched AccountNameB_ID. Is there a way that this can be done because a simple string match won't work with these.
The output would be formatted as:
public class AccountPair
{
public string AccountNameA { get; set; }
public int AccountNameB_ID {get; set;}
}
UPDATE
Some Clarification from my side, We have a CRM systems where the companies get created when a client signs up with us. After this, an employee will log onto our Web Application and recreate the Account there. Now when the CRM account gets created, a simple Company Trading name is used, but when the company gets created on our Web Application, the full company registered name is used, thus there is a difference in the company name between the two systems. I need to match the CRM company names with the WebApp company names and then store the WebApp CompanyID to the CRM Company profile so we can build further integrations between the CRM and the WebApp.