+ Reply to Thread
Results 1 to 2 of 2

clean duplicates in list

  1. #1
    Registered User
    Join Date
    06-14-2005
    Posts
    2

    clean duplicates in list

    hello,

    i need to clean a list of ipīs.

    the list looks something like this:

    677.37.198.243:3128
    677.37.198.244:3128
    132.72.23.10:3128
    133.43.189.20:8080
    134.2.205.228:3127
    140.112.107.80:3124
    140.112.107.80:3128

    i want to auto-delete every domain except the top level domains.
    so if the first two sets of numbers...
    ie.
    677.37.198.243:3128
    677.37.198.244:3128
    677.37.198.245:3128

    ...are the same, i want to delete every domain except of one.

    677.37.198.243:3128

    i hope someone can help me out

    greetz
    frank

  2. #2
    bj
    Guest

    RE: clean duplicates in list

    What is the unique domain identifier, and what makes it be the top level in a
    given domain?

    "frank101" wrote:

    >
    > hello,
    >
    > i need to clean a list of ipÂīs.
    >
    > the list looks something like this:
    >
    > 677.37.198.243:3128
    > 677.37.198.244:3128
    > 132.72.23.10:3128
    > 133.43.189.20:8080
    > 134.2.205.228:3127
    > 140.112.107.80:3124
    > 140.112.107.80:3128
    >
    > i want to auto-delete every domain except the top level domains.
    > so if the first two sets of numbers...
    > ie.
    > 677.37.198.243:3128
    > 677.37.198.244:3128
    > 677.37.198.245:3128
    >
    > ...are the same, i want to delete every domain except of one.
    >
    > 677.37.198.243:3128
    >
    > i hope someone can help me out
    >
    > greetz
    > frank
    >
    >
    > --
    > frank101
    > ------------------------------------------------------------------------
    > frank101's Profile: http://www.excelforum.com/member.php...o&userid=24310
    > View this thread: http://www.excelforum.com/showthread...hreadid=379167
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1