(Excel) GetBaseDomain

The GetBaseDomain method is a utility function that converts a domain into a "domain base", which is useful for grouping URLs. For example: abc.chilkatsoft.com, xyz.chilkatsoft.com, and blog.chilkatsoft.com all have the same base domain: chilkatsoft.com. Things get more complicated when considering country domains (.au, .uk, .se, .cn, etc.) and government, state, and .us domains. Also, domains such as blogspot, wordpress, etc, are treated specially so that "xyz.blogspot.com" has a base domain of "xyz.blogspot.com". Note: If you find other domains that should be treated similarly to blogspot.com, send a request to support@chilkatsoft.com.

Download Excel Class Modules Chilkat Excel Class Modules

Dim spider As Chilkat.Spider
Set spider = Chilkat.NewSpider

Debug.Print spider.GetBaseDomain("www.chilkatsoft.com")
Debug.Print spider.GetBaseDomain("blog.chilkatsoft.com")
Debug.Print spider.GetBaseDomain("www.news.com.au")
Debug.Print spider.GetBaseDomain("blogs.bbc.co.uk")
Debug.Print spider.GetBaseDomain("xyz.blogspot.com")
Debug.Print spider.GetBaseDomain("www.heaids.org.za")
Debug.Print spider.GetBaseDomain("www.hec.gov.pk")
Debug.Print spider.GetBaseDomain("www.e-mrs.org")
Debug.Print spider.GetBaseDomain("cra.curtin.edu.au")

' Prints: 
' chilkatsoft.com
' chilkatsoft.com
' news.com.au
' bbc.co.uk
' xyz.blogspot.com
' heaids.org.za
' hec.gov.pk
' e-mrs.org
' curtin.edu.a