Link to home
Start Free TrialLog in
Avatar of fixyfoxy
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
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fixyfoxy
fixyfoxy

ASKER

Patrick,

Super solution! Worked exactly as I needed it to....

MGandhi