600k Domain list, can't clean it [Help]

Heraclitus

Junior Member
Joined
Jan 29, 2014
Messages
136
Reaction score
10
I recently got my hands on a 600k domain list. But it has the domain and then the ip like this
domain.com 12.12.12.12

Is there anyway I can get rid of the ip and keep the domains only?
 

Sure.

1) Copy and Paste those on Notepad.
2) Replace the "free" space between the domains and the IPs with a tab space. (the button can be found on the left of your keyboard.)
3) Copy everything and Paste it on Excel.

You now have two separate columns. One for the domains and one for the IPs. ;)
 

Sure.

1) Copy and Paste those on Notepad.
2) Replace the "free" space between the domains and the IPs with a tab space. (the button can be found on the left of your keyboard.)
3) Copy everything and Paste it on Excel.

You now have two separate columns. One for the domains and one for the IPs. ;)

Awesome! I also found out how to select every ip with notepad by using \d+\d+...
Didn't know that feature of Excel, cheers!
 
Back
Top