Help with formula (remove text for say blog.website.com)

Hi,

I need some help with a question. I found an add in online that uses a formula that would take a list of URL's like this:

http://www.reddit.com/r/datasets/
http://www.di.unipi.it/~gulli/AG_cor..._articles.html
https://555.explore.data.gov/Other/D...alog/pyv4-fkgv

Down to this:

reddit.com
di.unipi.it
555.explore.data.gov

The nexzt step is to that the list down to this


reddit.com (no change)
di.unipi.it (remove di.)
data.gov (remove 555.explore)

So in the end I just want to end up with what is before the first period and what is after the last period.

I found out that if you do a Find and Replace with .* or *. it gives me the text after the last period or the text before the last period. This still doesn't suit what I need.

In the end say blog.dominik.com is the site. Then the blog part is called a subdomain of a website and I just want to filter the results of the 50,000 urls I have in a spreadsheet to just the main website and the extension of say .com. Somt he dn result should be dominik.com

Is there a formula for this? Or is there some way to filter how many periods are in a set of data so the site that are just website.com for example are at the top and the next set of date is like blog.wesbite.com and if there is a 3rd period the next set would be all the sites that would be 1.blog.dominik.com

Any help would be greatly appreciated!

Dominik

P.S. I know I can use Date > Text to colums and I setup a template for this with a copy and paste but it's still quite time consuming so that's not waht I'm looking for

Here.. Try to enter more web's for testing

Originally Posted by zbor

Here.. Try to enter more web's for testing

Love it! Zorb you don't understand how much time you just saved me man! Seriously I sincerely appreciate it man!

Originally Posted by martindwilson

well i suppose what i posted is not working then?

It just came back with that error where it says VALUE. All is good though, sharing is caring, thanks for replying also