i@m.fm

Frank Michlick’s blog

Entries Comments



Category: Work

Extract the TLD from a Domain in a Spreadsheet

6 December, 2011 (00:29) | Work | By: Frank Michlick

Time to activate this blog again, no? For our domain name sales reports over at DNN I needed a spreadsheet function that separates the TLD from a domain name. I’m using OpenOffice and am planning on switching to LibreOffice, but I think this should work in Excel as well.

So if the cell that contains the domain name is “A1″, this is my formula:

=RIGHT(A1;(LEN(A1)-SEARCH(“\.”;A1)))

The search statement determines the location of the first Dot counting from the left. This number is then deducted from the total length of the text in A1 and then separated from the rest of the string by using the “RIGHT” function.

Disappearing Google Alerts

2 August, 2007 (02:31) | Work | By: Frank Michlick

I used to use Google Alerts extensively in order to help me stay on top of certain companies and topics – amongst other reason to help me fuel my blogs. Well, I am not sure what is happening, but the alerts keep on disappearing. I have changed the email address (and Google) account I use to point to my Gmail account, to make sure that there are no bounces, but still keep on disappearing. I had re-added about 20 alerts and after 2 days I was down to 5 – 3 days later all of them were gone.

Since there’s barely any chance that my support email to Google will be answered, I was wondering if anyone else has experienced anything similar. I wasn’t able to find anything. Am I the only one encountering this problem?

Domain Name News

18 July, 2007 (22:23) | Work | By: Frank Michlick

Shame on me, I forgot to let my readers here know that I started a new blog together with Adam Strong: Domain Name News. DomainEditorial will be integrated into that blog. So if you are only finding about this now, go and read, you have lots to catch up with ;-)

Looking to sell dowloads? Try tradebit.com

15 May, 2007 (23:41) | Work | By: Frank Michlick

While my friends’ site TradeBit has been around for a while, I just realized that I never wrote about his site before. It allows you to upload your own files and sell them as downloads. So if you are looking to sell downloads, take a look at his site. You can even set up your own affiliate program.

SharedReviews.com launches

15 May, 2007 (23:15) | Work | By: Frank Michlick

If you’ve been wondering what I’ve been up to, check out what we (Peter, the rest of the team, and I) have created, as the first part of our new site launched today: SharedReviews.com, a product review website that shares the revenue with the community. Also Peter posted a nice introduction to the site.

For those of you wondering about DomainEditorial.com

30 March, 2007 (20:39) | Main Page, Work | By: Frank Michlick

For those of you asking me about my DomainEditorial.com Blog – yes, it’s down, I am aware of it and trying to get it back up as quickly as possible. On top of a move of the physical location of the server on Wednesday we are now facing some hardware issues on that server. Hopefully it will be back online today.

[Update]: It’s back up – but it’s running off one hard drive instead of two.

Leaving the herd – Auf Wiedersehen Tucows

14 February, 2007 (16:49) | Work | By: Frank Michlick

Leaving the herd – my time has come. Life is full of change. Last
year was full of change with the birth of my son – so why stop there?
The era of change continues this year, with a big and important step
for me.

I will be leaving Tucows as of March 1st, 2007. Leaving the
herd was a difficult decision, especially after a full 5 years and 8
months of work with many wonderful people. I was the first Sales
Engineer to be hired by Tucows and it was an amazing opportunity to
help share and validate this position.

Thank you, Tucows, colleagues, ex-colleagues, suppliers,
partners and resellers for the amazing time I’ve had. I am hoping to
stay in touch with as many of you as possible.

But for me it is time to move on, time to move out of the barn.

Unfortunately at this point in time, I am not at liberty to
reveal a whole lot of what I will be doing. I can however say, that I
am looking forward to working a lot more with Peter, since he happens
to be the founder of the startup that I am co-founder of.

Stay tuned for more…

PS: Happy Valentine’s day!

Back from Traffic

30 October, 2006 (00:16) | Work | By: Frank Michlick

I just got back from the Targeted Traffic Conference in Hollywood Florida last night. Peter has got some coverage at ClickToHit and my other blog DomainEditorial.com features some posts as well. What a great conference and great networking. Wow!

Check out my other blog!

26 October, 2006 (09:25) | Main Page, Work, Work/Domains, Work/InterNETionalize! | By: Frank Michlick

Please also take a look at my blog about and for the Domain-Industry:
http://DomainEditorial.com/

Ajax RSS generator

31 July, 2006 (20:38) | Work | By: Frank Michlick

Now here’s a tool that I have been waiting for a long time: Ponyfish.com. Since the name is anything but self-explanatory, here’s a quick review.

Ponyfish is an RSS generator for sites that do not offer RSS-Feeds. But instead of writing complex regular expressions, Ponyfish uses Ajax in order to select what to place in a feed. I already tried it for one website where I miss a feed, and it worked fine with one small manual edit. Great idea, even better execution.The only downside is that it currently only works of the title/headline of the post actually is a link, but it’s a great start.

[via Phlow.net]