getDomain ( theAddress )

parses the domain name from an email address or URL

Average rating: 4.3 (37 votes) Log in to vote

Andrew Sasaki - Show more from this author

Sample input:

http://www.mywebsite.co.uk/test/index.html

user@testdomain.net

Sample output:

mywebsite

testdomain

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( [ 
/* get everything to the right of '@' or '//' */
fullAddress = Case ( PatternCount ( theAddress ; "//" )  > 0 ; RightValues ( Substitute ( theAddress ; "//" ; "¶" ) ; 1 ) ; PatternCount ( theAddress ; "@" )  > 0 ; RightValues ( Substitute ( theAddress ; "@" ; "¶" ) ; 1 ) ; theAddress ) ; 
/* for a URL, strip everything starting from the first '/' */
stripSubAddress = LeftValues ( Substitute ( fullAddress ; "/" ; "¶" ) ; 1 ) ; 
/* divide the address into subcomponents */
addressValues = Substitute ( stripSubAddress ; "." ; "¶" ) ; 
/* count the subcomponents of the address */
addressValueCount = ValueCount ( addressValues ) ;
/* get the next-to-last subcomponent */
penultimateAddressValue = MiddleValues ( addressValues ; addressValueCount - 1 ; 1 ) ;
/* convert the value to text */
penultimateAddressWords = LeftWords ( penultimateAddressValue ; 10 ) ;
/* 'com' or 'co' in next-to-last address component indicate a "country" address */
domainValue = If ( penultimateAddressWords = "com" or penultimateAddressWords = "co" ; MiddleValues ( addressValues ; addressValueCount - 2 ; 1 ) ; MiddleValues ( addressValues ; addressValueCount - 1 ; 1 ) ) ] ;
/* convert the domain value to text */
LeftWords ( domainValue ; 10 ) )
/* note: the '10' is arbitrary, to capture domains like 'four-word-domain-name.com' */

Given a web address or URL, will strip out everything but the domain name. Works for many "country" addresses as well (example: "https://photos.mydomain.com.au/" resolves to "mydomain").

Function updated 2008-03-08 to properly capture domains like "my-multi-word-domain-name.com", and is now commented.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

getDomain ( theAddress )

Comments

Support this website.

Support this website.