Raj,
It looks to me like you're going to have to do some rule based ETL.
Start by parsing your URIs on the dots into varrays and then examinining
data .... if seg. first == 'www' and seg.last == "com" then harvest
seg.length-1 ...
if seg.last='uk' and seg.length-1='co' then harvest seg.length-2 ...
et cetera ad endless nauseam.
Good luck
rjamya wrote:
If I don't distinguish "blueyonder.co.uk" and "demon.co.uk", it will be just "co.uk" and that means most of commercial domains under UK tld. It will be akin to bundling most of us sites under ".com" alone.
if I had to take only the last 2 parts, it is a piece of cake, I wouldn't trouble this list for such a small RTFM issue. The problem I have is much more complicated.
And no, this isn't a rhetorical question at all. Raj
On 4/10/06, sol beach <sol.beach@xxxxxxxxx> wrote:
Rhetorical question -
On what basis will the s/w "decide" whether 2 (akamaistream.net) parts or 3 (blueyonder.co.uk) parts is the "right" answer?
On 4/10/06, rjamya <rjamya@xxxxxxxxx> wrote:
Basically I am looking to isolate just the (distinct) domain name from fully qualified domain names that you'd normally see in web-surfing.
I am working on couple of techniques, but it gets complicated since TLDs differ in format and there is only so much you can do with substr().
-- ---------------------------------------------- Got RAC? -- //www.freelists.org/webpage/oracle-l