Converting hypertext to text

[Kevin Bruce]

I am attempting to convert hypertext email addresses back to text so that I
can program automation routines. In doing so, the text comes up in one of
the the following structures:

(e-mail address removed)#mailto:[email protected]#

(e-mail address removed)#mailto:[email protected]

#mailto:[email protected]#

I need to get rid of everything except the actual email address, but
attempts to isolate the characters between and including the "#" signs, has
proven fruitless. Access must be reading these as reserved characters, or
something.

How can I get rid of all the extraneous characters without editing some two
thousand records by hand?

Thanks.

_Kevin

--
================================
Kevin Bruce
Program Coordinator
ArtStarts in Schools
301 - 873 Beatty Street
Vancouver, BC V6B 2M6

ph:604-878-7144 ext.3
fx: 604-683-0501

web: www.artstarts.com

Did you know that you can donate to ArtStarts in Schools directly from our
website? www.artstarts.ca

 

[[MVP] S.Clark]

The only constant appears to be the fact that everything after the colon,
except the # symbol, is the email address.

So, use instr to find the colon, then Mid everything after it. Check if the
last character, using Right, is the #, and if so, scrape it off.

About 6 lines of VBA code.

 

[Altadoc]

I have two tables, one with personal information and another that relates
persons to particular files. I made a simple query of the second table such
that I get output something like

File# Jones Smith George 2, 3, 1

as the five fields of the return. The fields called in the query with
Jones' name is the same as the one called for the concatonated field and the
IDs returned are the correct ID's. Why can't I get 'Jones, Smith, George'
instead of '2,3,1' in the final field?