How can I remove a known IP range from my extracted IP's? I am running a report on some data that leaves me with a list of IP's but there is a subset of IP's I want to ignore. Also, is there a way to remove duplicates but leave the number of hits - ie address 9.204.150.192 hitcount 2?

Assume you want to remove all IP of 190.x.x.x-195.x.x.x 1. ctrl-o open text file that contain IP list, one in each line 2. ctrl-h open 'replace' dialogue * set 'replace unit' to 'Line' * set 'search for pattern' to:

3. click 'replace', all 190-195 ip address will be removed 4. select 'replace->replace by template->word frequency statistics->count and sort frequency of all line' menu 5. click 'ok', and click 'replace', all lines will be sorted by frequency, and the duplicated IP are removed.

Note: after the operation, system will generate 2 scripts automatically, you can save these 2 scripts into one script file(rst) and reuse it later.