Hello eveyone,

I am trying to trim out the field that contains full urls into only domains.

Eg.

http://subdomain.domain.com/contact.html

http://images.yahoo.com/userx/folder/image.jpg

http://www.google.com/search?q=filemaker&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1

into:

http://subdomain.domain.com

http://images.yahoo.com

http://www.google.com

so I found this works:

Trim ( Substitute ( MiddleValues ( Substitute ( DestinationURL; ".com"; "¶"); DestinationURL; 1); "¶"; "" ) )&".com"

------------------------- ------------

but how to implement some form of variable to cover all domain extensions?(tv,org,edu,com,...)

my poor logic would be:

-------------------------------------

DomainVAR = .net .com .tv ....(all possible)

Trim ( Substitute ( MiddleValues ( Substitute ( DestinationURL; "DomainVAR"; "¶"); DestinationURL; 1); "¶"; "" ) )&"DomainVAR"

-------------------------------------

Or does this have to be scripted?

Thanks for your time!

Left(MyURL; Position (MyURL ; "/" ; 1 ; 3 ) -1)

Thanks sbg2,

I compleatly overlooked the pattern of "/" is always accounted 3 times.

Thanks a bunch!

what happens if there is no third slash?

http://www.fmforums.com

Do all fields have to be a longer url? Just curious here.

How about:

Let (

text = MyURL & "/"

;

Left ( text ; Position ( text ; "/" ; 1 ; 3 ) - 1 )

)

Thanks Zero Tolerence for pointing this out.

Comment, thanks for the final touch!