Re: What are the valid characters in an email address?

Since the @ sign seems to be universal to your problem can you scan for the
@ signs, and then scan left and right  for the first blanks or first
parentheses?  Could you also xlate the parentheses to blanks, then scan left
and right for just the first blank?  Would there be too many false
positives?  If there were false positives would it be serious?
 

---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: 1/12/2004 2:50:02 PM
To: Midrange Systems Technical Discussion
Subject: Re: What are the valid characters in an email address?
 
Scott,
 
In the msf journals I have one field containing several data elements.  I
have to strip out the email address which "generally" starts in the same
place.  The problem is that an acceptance and a rejection may have the
same email address, however one may have put the <...> around it.  I am
trying to strip it down to the basics so that they look the same.  Then I
am going to use SQL to find sends without either an acceptance or a
rejection.  Bad enough I am using a UDF to strip out the email.  Using a
UDF to validate domain names via your method may get even slower.