fixyfoxy
asked on
Microsoft Access Extract Domain Name from Hyperlink or text field
Hi,
I'm working on an access database that stores lists of URL's
My challenge (and I'm really hoping you can help) is to append 2 additional columns to the table that contains the URL's and in that column extract the domain and domain suffix.
.
For example, the table may contain the following column
http://www.abc.com
www.xyz.com
123.mno.net
http://www.abc.com/category
www.abc.net/category/sub-category/index.html
xyz.info/index.php
www.abc.com:8082/
What I'd like as the output for each of these rows is
Domain Suffix
www.abc.com com
www.xyz.com com
123.mno.net net
www.abc.com com
www.abc.net net
xyz.info info
www.abc.com com
Thanks!
M Gandhi
I'm working on an access database that stores lists of URL's
My challenge (and I'm really hoping you can help) is to append 2 additional columns to the table that contains the URL's and in that column extract the domain and domain suffix.
.
For example, the table may contain the following column
http://www.abc.com
www.xyz.com
123.mno.net
http://www.abc.com/category
www.abc.net/category/sub-category/index.html
xyz.info/index.php
www.abc.com:8082/
What I'd like as the output for each of these rows is
Domain Suffix
www.abc.com com
www.xyz.com com
123.mno.net net
www.abc.com com
www.abc.net net
xyz.info info
www.abc.com com
Thanks!
M Gandhi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Super solution! Worked exactly as I needed it to....
MGandhi