TLD ( text )

This is a Top-Level Domain (TLD) Extractor that captures the TLD from a URL with the assumption that the URL is valid.

Average rating: 3.5 (2 votes) Log in to vote

Robert Jackson
RJPlus Consulting
https://twitter.com/robertjackson

Sample input:

TLD
(
"http://www.bbc.co.uk/sport/football/teams/aberdeen"
)

Sample output:

bbc.co.uk

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

//TLD (text)   

Let 
(
[
url =  text ;
length = Length (url );
startPosition =  Position ( url ; "." ; 1; 1 );
numberSlashes =  PatternCount (url ; "/");
endPosition = Position ( url ; "/" ; 1; 3  ) ;
topleveldomain = 
Case 
( 
numberSlashes = 2 ; Middle ( url ; startPosition + 1 ;  length  - startPosition );
Middle ( url ; startPosition + 1 ;  endPosition  - startPosition - 1 )
);
result = topleveldomain
];
result
)

This is a Top-Level Domain (TLD) Extractor that captures the TLD from a URL with the assumption that the URL is valid.

Comments

		Philip McGeehan, SMD Ltd Jul 13, 2020
Doesn't work for "http://bbc.co.uk/sport/football/teams/aberdeen"

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

TLD ( text )

Comments

Support this website.

Support this website.