How can I remove....

Quiksilver

Diamond Member
Jul 3, 2005
4,725
0
71
Does anyone here know how I can remove letters or symbols from a massive list without having to site here and do it all by hand?

The reason is, I hage a huge ip blocklist (about ~50MB) all with names and reasons next to ip ranges. Well I want to remove the names and reasons but keep the ip ranges.

Is there a way to do this? It's also not all the same name so I can't just find one name and remove i using replace all.

Example:
Joes-hogs[spyware]:20.3.12.88-20.3.12.110

I want it be:
20.3.12.88 - 20.3.12.110
 

mechBgon

Super Moderator<br>Elite Member
Oct 31, 1999
30,699
1
0
Hmmm :confused: If nothing else, you could plunk the list into Word and use Replace to replace each alphabetical character with -nothing-. Do that 26 times for a-z, plus any characters such as [] in your example.

Any good? :confused:
 

Quiksilver

Diamond Member
Jul 3, 2005
4,725
0
71
I was gonna do that but I thought I would ask first; just in case their is some easy way to do it and won't take me hours to do like that solution :p