Advertisement
Guest User

Untitled

a guest
Jan 25th, 2017
22,819
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. %%%%%%%%%%@yahoo.com
  2. %%%%%%@wanadoo.fr
  3. %%%%raviplywoodglasscentre@yahoo.comravi
  4. %%nameemail%%@yahoo.com
  5. %.getincontact@numberland.com
  6. %1%3@example.com
  7. %1@example.com
  8.  
  9. yahoo.com,%%%%%%%%%%@yahoo.com
  10. wanadoo.fr,%%%%%%@wanadoo.fr
  11. yahoo.comravi,%%%%raviplywoodglasscentre@yahoo.comravi
  12. yahoo.com,%%nameemail%%@yahoo.com
  13. numberland.com,%.getincontact@numberland.com
  14. example.com,%1%3@example.com
  15. example.com,%1@example.com
  16.  
  17. yahoo.com,%%%%%%%%%%@yahoo.com,%%nameemail%%@yahoo.com
  18. wanadoo.fr,%%%%%%@wanadoo.fr
  19. yahoo.comravi,%%%%raviplywoodglasscentre@yahoo.comravi
  20. numberland.com,%.getincontact@numberland.com
  21. example.com,%1%3@example.com,%1@example.com
  22.  
  23. $ perl -F@ -alne '
  24. push @{ $h{$F[1]} }, $_ }{
  25. for $k (reverse sort keys %h) {print join ",", $k, @{ $h{$k} }
  26. }' emails.csv
  27. yahoo.comravi,%%%%raviplywoodglasscentre@yahoo.comravi
  28. yahoo.com,%%%%%%%%%%@yahoo.com,%%nameemail%%@yahoo.com
  29. wanadoo.fr,%%%%%%@wanadoo.fr
  30. numberland.com,%.getincontact@numberland.com
  31. example.com,%1%3@example.com,%1@example.com
  32.  
  33. python3 /path/to/group_domains.py /directory/with/files
  34.  
  35. example.com,%1%3@example.com,%1@example.com
  36. numberland.com,%.getincontact@numberland.com
  37. wanadoo.fr,%%%%%%@wanadoo.fr
  38. yahoo.com,%%%%%%%%%%@yahoo.com,%%nameemail%%@yahoo.com
  39. yahoo.comravi,%%%%raviplywoodglasscentre@yahoo.comravi
  40.  
  41. lines.sort(key=itemgetter(1))
  42.  
  43. groupby(lines, itemgetter(1))
  44.  
  45. some_list.txt
  46.  
  47. grouped_some_list.txt
  48.  
  49. python3 /path/to/group_domains.py /directory/with/files
  50.  
  51. python3 /path/to/group_domains.py /directory/with/files /path/to/outputfile.txt
  52.  
  53. awk -F, '{a[$1] = a[$1]","$2} END {for (i in a) print i a[i]}'
  54.  
  55. $ awk -F, '{a[$1] = a[$1]","$2} END {for (i in a) print i a[i]}' foo
  56. yahoo.comravi,%%%%raviplywoodglasscentre@yahoo.comravi
  57. yahoo.com,%%%%%%%%%%@yahoo.com,%%nameemail%%@yahoo.com
  58. numberland.com,%.getincontact@numberland.com
  59. example.com,%1%3@example.com,%1@example.com
  60. wanadoo.fr,%%%%%%@wanadoo.fr
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement