Enjoy unlimited access to all forum features for FREE! Optional upgrade available for extra perks.

dupes in list

Discussion in 'Domain Research' started by stender, Oct 26, 2008.

Thread Status:
Not open for further replies.
  1. stender United Kingdom

    stender Well-Known Member

    Joined:
    Nov 2005
    Posts:
    2,501
    Likes Received:
    30
    Anyone know of a pc tool which will remove duplicate lines from a list?

    I currently use unix or sql but was wondering if theres an easier way to remove dupe rows from an excel list?
     
  2. Domain Forum

    Acorn Domains Elite Member

    Joined:
    1999
    Messages:
    Many
    Likes Received:
    Lots
    IWA Meetup
     
  3. Skinner

    Skinner Well-Known Member

    Joined:
    Jul 2008
    Posts:
    4,616
    Likes Received:
    140
  4. grantw United Kingdom

    grantw Well-Known Member

    Joined:
    Mar 2005
    Posts:
    4,694
    Likes Received:
    93
    I always use textpad (textpad.com) - Tools > sort > remove duplicates > job done

    Grant
     
    Last edited: Oct 26, 2008
  5. Admin

    Admin Administrator Staff Member

    Joined:
    Jun 2004
    Posts:
    11,120
    Likes Received:
    464
    DNA Pro removes dupes automatically too
     
  6. stender United Kingdom

    stender Well-Known Member

    Joined:
    Nov 2005
    Posts:
    2,501
    Likes Received:
    30
    Oh the pain! all those wasted hours i could of been doing something else!

    next you'll be telling me textpad can do sed and awk!
     
  7. grantw United Kingdom

    grantw Well-Known Member

    Joined:
    Mar 2005
    Posts:
    4,694
    Likes Received:
    93
    There's a shed load of plugins for it, I haven't found anything it can't do yet.
     
  8. aZooZa

    aZooZa Well-Known Member

    Joined:
    Nov 2005
    Posts:
    4,875
    Likes Received:
    253
    If you use Unix, you could do it like this in a flash:

    sort inputlist >s; uniq s >outputfile; rm -f s
     
  9. stender United Kingdom

    stender Well-Known Member

    Joined:
    Nov 2005
    Posts:
    2,501
    Likes Received:
    30
    I use unix at work but was at a loss at home. Keep meaning to install solaris on a vm at home.
     
Thread Status:
Not open for further replies.