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 > >
