Need help with truncating text

[Rich S]

Howdy, howdy:

I have a field in my solution that records URLs, but it gets unwieldy when printing their paths, which can be very long. What I need is a separate calc field to truncate the text so everything after .com, .org, .net, etc., is deleted. How do I do that?

TIA for your help!

Rich

[comment]

Haven't tested this, but try:

Let ( [

adj = Substitute ( URL ; "//" ; "§" ) ; 

pos = Position ( adj ; "/" ; 1 ; 1 ) ; 

top = Case ( pos ; Left ( adj ; pos - 1 ) ; adj ) 

] ;

Substitute ( top ; "§" ; "//" ) 

)

[Rich S]

Works like a charm! I wish I had 1% of the FMP smarts you have; I'd even settle for 0.5%.

Now that I know it works, I'll need to sit down for a few hours to figure out _how_ it works. Thanks again!