Sorting an email list with PHP?

[internetheaven]

I have a ex-client email list of 10000+ email addresses. It looks something like this:

[e-mail]
[e-mail]
[e-mail]
[e-mail]
[e-mail]
[e-mail]
[e-mail]
[e-mail]
[e-mail]

is there any way in PHP, Excel or anything - that will organise this list into separate files where only one occurrence of each company name is in each list? e.g.

LIST 1

[e-mail]
[e-mail]
[e-mail]

LIST 2

[e-mail]
[e-mail]
[e-mail]

LIST 3

[e-mail]
[e-mail]

LIST 4

[e-mail]

I've been trying to do it manually, and my eyes are going fuzzy! It's taking forever.

Thanks
Mike

[jatar_k]

I might explode them into a db with fullemail, person, domain and then you could do selects with group by or distinct

you could then store other info and have a little crm going

[dmorison]

Hi Mike,

With the list saved as list.txt in the same folder, have a go with the following:

<?php
 header("Content-Type: text/plain");
 $lists = array();
 $list = fopen("list.txt","r");
 while(!feof($list))
 {
 $email = trim(fgets($list));
 if ($email)
 {
 $parts = explode("@",$email); 
 // find the first list without an address for example.com ($parts[1])
 $i = 1;
 while(isset($lists[$i][$parts[1]])) $i++;
 // ...and add the address
 $lists[$i][$parts[1]] = $email;
 }
 } 
 //dump the lists
 foreach($lists as $n => $emails)
 {
 print "List ".$n."\n\n";
 print implode("\n",$emails)."\n\n"; 
 }
?>