Need Formula to Extract Part of URL 1

[schief13]

Hello, I have a field that consists of URL's visited by multiple users such as

http://www.yahoo.com/black

http://search.yahoo.com/new

http://signin.yahoo.com/mail

http://www.epix.net/

http://cgi.epix.net/blue

I am using Crystal reports v9 and am looking to create a formula to be able to extract the yahoo.com or epix.net from the strings to summarize.

Thanks

 

[bdreed35]

This will work for all the examples that you provided:

//@Extract
stringvar url := {table.url};
split(mid(url,instr(url,".")+1),"/")[1]

~Brian

 

[schief13]

Brian,
Works perfectly! Thanks