Powerful CCK URL entry

Hi Everyone,

I have interesting problem that I am hoping to get some guidance on:

My website involves users making recommendations of other companies. In affect they do nothing more than create a page outlining their experiences, etc.

What I want to happen is for them to enter the URL of the website they are referring to on the page they post.

It is easy enough to make a CCK text field which grabs URL data, and displays it - but I want this particular input to be much more powerful than that.

First I want people to be forced to input the URL in a specific way (i.e. http://www. instead of www., or the other way around - it doesn't matter as long as its consistent).

Next, I want some way for the website to compare what they have input into this field with the existing URLs placed by other members so that the site can either lump the new page with the existing "www.google.com" entries, or, if this is the very first one - create a new category of "www.google.com" entries.

This way, I can reference them later (as in "place this ad on all www.google.com recommendations", or "show me all www.google.com recommendations")

This seems like a problem which would be solved by having a number of modules work together - and likely a problem which has been efficiently solved before. However, after digging around in the forums and looking through loads of different modules I still haven't come up with the best method to implement this.

I am thinking that having a CCK field that auto creates a taxonomy term... but that is about as far as I have managed to get in the thought-process as I have not managed to find an easy way to do this.

Does anyone have a good suggestion or a bit of guidance?

In the event I have posted this in the wrong place, please forgive me and possibly direct me to the best location to post.

Thanks so much for all your help.