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