email edit

Nancy Palmquist nlp at vss3.com
Wed Nov 1 06:59:48 PST 2006


Jay R. Ashworth wrote:
> On Tue, Oct 31, 2006 at 10:06:52AM -0500, Nancy Palmquist wrote:
> 
>>One I have used is the following:
>>
>>email: [{!" "!}] { {A} | {N} | clean }
>>clean: {!">"! | !","! | !"$"! | !"%"! | !"<"! | !"?"! | !"#"! | * }
> 
> 
> "%" is still valid on the LHS of an email address.  It's not too
> *common* anymore... but it's still in use.
> 
> As is "+".
> 
> 
>>That eliminated most of the garbage, but I recently ran across a company 
>>that allowed their email addresses to contain apostrophes, a real bad 
>>character in my view.  Hard to edit for in filePro.
>>
>>But maybe this would be better:
>>
>>some: {{A} | {N} | clean}
>>email: [{!" "!}] some "@" some "." some
>>
>>Just include in the CLEAN edit all the characters that are never allowed 
>>in any part of an email address.  You are not able to check for 
>>apostrophes or quotes, but all others will work.
>>
>>Domains are hard to restrict, they keep adding new ones so I try not to 
>>worry about it.
> 
> 
> No, but it is useful to validate the RHS for "At least one dot", though
> it might not be all that easy...
> 
> Cheers,
> -- jra


The discussion makes it clear why it is not possible to make a distinct 
edit.  Some tuning would have to happen and it would not always work, 
but like a date edit you could design one for the standard and one for 
the 2 dot emails and test the email against both, if it passes either it 
  is a good email address.

I think the solution is some edits for the various formats and then some 
processing to see if it complies with any edit.

Your scope of customers might determine if one would work or you need 
more depth for global email options.

Nancy


-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com



More information about the Filepro-list mailing list