LINQPad query to take a listing of emails, with some items containing comma-delimited list of emails, and finds distinct ones.
var emails = new List<string>()
{
"test.one@example.com",
"test.one@example.com, test.two@example.com",
"test.two@example.com"
};
var cleanedEmails = new List<string>();
foreach (var email in emails)
{
if (email.Contains(","))
{
cleanedEmails.AddRange(email.Split(','));
}
else
{
cleanedEmails.Add(email);
}
}
cleanedEmails.Select(c => c.Trim()).Distinct().OrderBy(c => c).Dump();