David is correct, .tv is Tuvalu, but they sold the rights to the .tv domain a few years ago, so, it's a bit of a special case, in that it's a country TLD, but is not treated as such..... Here's a link to an article on the sale of the .tv domain: http://news.bbc.co.uk/1/hi/sci/tech/149084.stm -Mark -- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Aldridge Sent: Monday, April 10, 2006 2:34 PM To: richard.c.ji@xxxxxxxxx; rjamya@xxxxxxxxx Cc: Stephane Faroult; Oracle Discussion List Subject: Re: Algorithm or ideas wanted for creative text parsing .tv = Tuvalu http://www.iana.org/cctld/cctld-whois.htm --- Richard Ji <richard.c.ji@xxxxxxxxx> wrote: > Raj, > > .tv is 2 characters yet its' not a ccTLD, you need to get a list of > valid ISO two letter country codes. > > Richard Ji > > On 4/10/06, rjamya <rjamya@xxxxxxxxx> wrote: > > Thanks SF and all > > > > maybe here is what I can do ... > > > > 1. if the domain is numeric, take it as it is 2. if the TLD (i.e. > > the last piece) is 3 or more characters, you take last 2 pieces > > (this will cover com,org,edu,name,info,museum etc) 3. if the > > last piece is 2 characters (most likely a ccTLD), take last 3 pieces > > (i.e. il, br, ca, uk etc) > > > > hmmm ... looks promising, am I missing anything? > -- > //www.freelists.org/webpage/oracle-l > > > > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l