Thank you for your help!
------------------------------------------------------------------------
On 2017-12-11 22:43, Igor Tandetnik wrote:
On 12/11/2017 12:22 PM, Klaus Maas wrote:
There is 1 item in the last where condition of which I do not
understand the purpose:
(instr(subdomain, '.') = 0 and subdomain = long)
That's a zero-dot case, when the original domain is simply 'com', say.
Added for completeness.
This means that anything in the form of 'ftp://test/' would output
the string between the two delimiters (:// and /), in this case 'test'.
But that is not a domain name in the format domain.tld.
Feel free to adjust to taste.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
