Parsing an email address from a string? (A97)

[MLH]

I haven't run into this exact scenario before. I imagine
there's a simpler approach to extracting the email addr
than in other situations I've faced.

Consider a table of records consisting of a single text
field with stuff like this in it...

RawData
Julia Dancy jd****@dot.something.va.us
Eileen Dannacker Ei**************@Qmail.net
Joel Dascal Jo*********@denr.gov
Melinda Dascott Me*************@aol.com
tania dautlick ta************@whatever.org
Cliff Dautrich Cl************@aia.org

.... in general...
John K. Doe (manager) So*********************@this.that.com

Notice that the email address is the LAST thing in each record.
The name on the left, however, can be any number of space
separated strings and may include more than just the name
itself (titles, positions, etc). Am seeking to put everything to the
left of the email address in Field1 and the email addr in Field2.

[pietlinden]

one way is to reverse the string, take everything from the left up to
the space and then reverse it again. So you're just using Mid and LEFT
and all those, but you're reversing the string first.

[MLH]

What a GREAT idea! Thx pietlinden, think I can handle that one.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On 27 Oct 2005 13:54:35 -0700, pi********@hotmail.com wrote:

one way is to reverse the string, take everything from the left up to
the space and then reverse it again. So you're just using Mid and LEFT
and all those, but you're reversing the string first.