J
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
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