Greets, all:

This is what I get for switching to decaffeinated coffee: I can't figure out how to modify this calc so it truncates the prefix to a URL:

Let(

[

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

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

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

];

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

)

As is, the calc does a nice job of truncating a URL's path so:

http://www.career-launcher.com/help/how_to_find

...becomes...

http://www.career-launcher.com

However, I want to truncate the URL even further by removing everything to the left of the URL so it reads:

career-launcher.com

TIA for your help!

Rich

Try =

Let ( [

adj = Substitute ( "§" & URL ; [ "§http://www." ; "" ] ; [ "§http://" ; "" ] ; [ "§www." ; "" ] ) ;

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

] ;

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

)

Thanks! Brilliant, as usual.