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

[Heraclitus]

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?

 

[PrinceVisi]

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.

 

[Heraclitus]

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!