HI
search for "@" and on the left part of the string from @ search for "."
wenn the result is ok - so you will have a correct address
sincerely
Franz
Chris Bia schrieb:
Hello Brian !
Mmm, i need something of very very very simple because i've a lot of cells
of this:
[email protected] (correct)
hotmail (not correct, so i must eliminate)
ma...@hotmail (not correct, so i must eliminate)
So, i'm triyng to find the cells that not contain a "dot" or a "@"
For example a regex like this: [^\.]
This expression should find me all strings that not contain a dot...but
naturally don't work XD
I have already eliminated email like this: " [email protected] " with " \-$
"
I'm very newbie in regex..any helps would be appreciate !
On Mon, Mar 9, 2009 at 2:54 PM, Brian Barker<[email protected]>wrote:
At 13:36 09/03/2009 +0100, you wrote:
Hello, I need a regex to find cells that NOT correspond to an email
address.
The simple answer appears to be that to test an e-mail address fully to the
RFC requires a very complex expression. See
http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html<http://www.ex-parrot.com/%7Epdw/Mail-RFC822-Address.html>.
See also
http://en.wikipedia.org/wiki/E-mail_address .
If you accept some restrictions - perhaps not to allow some otherwise
permitted characters in the local part or perhaps to permit the forbidden
consecutive dots there - the expression could be made a lot simpler. Do you
want to accept local-p...@[127.0.0.1] ?
I trust this helps.
Brian Barker - privately
