advice Extract domain names from a large .txt file

[Charley]

How to extract gTLD's from a large text file?

 

[dordomai]

Extract where? How is the data formatted? Does it contain anything else than domain names?

Do you want to extract all domains or just some?

How large is the file?

 

[Charley]

its 2000 KB text file. It's filled with domains, serial numbers, name servers, etc.

I want to extract all gtld domains

 

[dordomai]

can you post a sample line? gTLDs= .com, .net or nGTLDs?

 

[Charley]

all are ngtlds

 

[dordomai]

all are ngtlds

so do you want to extract all domains or just the ones that are nGTLDs?

 

[Charley]

I want to extract all nGTLDS only.

 

[dordomai]

it's probably not difficult if you know some basic programming (php, python etc.)

If not, maybe a member could do it for you.

Not sure it it could be done with Excel or any other program. Also hard to say without seeing the data.

You can filter CCTLDs if you filter anything that has 2 characters after the last dot in the domain.

Then for the legacy TLDs you need to come up with a list manually but that should not be difficult and then filter out all extensions that are in the list.

Any remaining domain that contains more than 1 dot is a subdomain and needs to be filtered out as well.

 

[golan]

You should learn about regular expressions. Quite easy and will serve you a lot in the future. Otherwise, use special software like Textpipe.

 

[Charley]

I tried some softwares on Google search, but none of them extracted the ngtlds.

 

[GBA]

Send me a sample, I will take a look and help you out

 

[Jurgen Wolf]

estibot.com can do Extract, the only one tool that I use there...

 

[wayne wooldridge]

Send me the list and I'll do it for you, and show you how

 

[Jimmy.com]

https://brainstorm.domains/domain-name-filter-pro/

This should do exactly what you need.

 

[ambrose.xu]

u have to learn basic programming , then use python or bash to fiter .txt files.