Hello Folks,
I have a requirement to extract the domains from a list of URLs. I know this is quite trending and a petty common topic across generic internet search, however no formulas quite seem to match my specific query.
My file has a list of domains (which include subdomains and multiple TLDs). I only need to extract the parent domain and strip off any subdomain or TLD(s) from the list.
Example:
<tbody>
</tbody>
Note: there are multiple TLDs and multiple sub-domains. I know its quite troublesome, but would be great if someone can help.
Thanks
I have a requirement to extract the domains from a list of URLs. I know this is quite trending and a petty common topic across generic internet search, however no formulas quite seem to match my specific query.
My file has a list of domains (which include subdomains and multiple TLDs). I only need to extract the parent domain and strip off any subdomain or TLD(s) from the list.
Example:
Domain | Extracted |
www.sub.domain.com | domain |
https://sub.domain2.com | domain2 |
domain3.com.ru | domain3 |
www.sub2.domain4.com.fl | domain4 |
sub1.sub2.domain5.org.fl | domain5 |
<tbody>
</tbody>
Note: there are multiple TLDs and multiple sub-domains. I know its quite troublesome, but would be great if someone can help.
Thanks