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 :


and i'd like to get only the 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


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,