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 -- frank101 ------------------------------------------------------------------------ frank101's Profile: http://www.excelforum.com/member.php...o&userid=24310 View this thread: http://www.excelforum.com/showthread...hreadid=379167 |
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 |
All times are GMT +1. The time now is 04:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com