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