AnsweredAssumed Answered

How to get a domain name from a url through calculation

Question asked by alexissindicic on Jul 19, 2017
Latest reply on Jul 23, 2017 by alexissindicic

Hello Filemaker Community,

 

I have a field called Referring_Page_Url with urls like :

http://www.blabla.eu/category/page

 

and i'd like to get only the blabla.eu in a new field called Domain_Name

 

My first idea was to define Domain_name as a result of this calculation :

 

Substituer ( Referring_Page_Url ; ["http:";""];["https:";""];["//";""] ; ["www.";""] )

 

it works for the first part of the Url but not for what is after the /->

so i get urls like

 

blabla.eu/category/page

 

Do you know what i could do to get rid of the /category/page

 

i was thinking of regular expression but there may be something easier un FM ?

 

Thanks you VERY much for your thoughts,

Outcomes