Trim Web Sites

[James]

Ok, someone provided this for me to trim the http:\\ and everything after
the first \

Mid([WebProxyLog.uri],8,InStr(Right([WebProxyLog.uri],Len([WebProxyLog.uri])
-7),"/")-1) AS Expr1

How would I alter this to leave the http:\\ as it has problems when there is
no http, or when its https.
So I want it to only trim the ending of the web site

Thanks

 

[Douglas J. Steele]

Change the 8 to a 1.