Validating email addresses

[noelgarry]

Hi
I have a large file where I am trying to clean up the data.
One of the fields is the email address.
I want to check if the email address has something followed by an @ symbol followed by something else. If it does not, then I want to replace it with a null value.
Can you help?
I thought that I could use the wildcard features such as <>*@* but this does not appear to be working.
Noel

 

[Mike375]

Having *@* as query criteria will find the records with @. You could then just do a copy/paste or update query into a field and only those records that have the @ will get an entry in the other field.

I

 

[noelgarry]

The *@* criteria does not appear to be working for me.
I was putting in <>"*@*" is this correct.
What I am intending is that the field is not equal to anything followed by an @ followed by anything?
Noel

 

[ajetrumpet]

Garry,

I wonder if the solution I posted for you in the other thread would work here too...???

Also, look these up in access help:

LEFT()
RIGHT()
MID()
"LIKE" keyword.

Check this out too:
http://www.access-programmers.co.uk/forums/showthread.php?p=671288#post671288

 

[Mike375]

*@* worked for me because I just checked it as I was not 100% that @ would be OK.

Not Like "*@*" works for me.

Make sure the " " are either side. Mine does it automatically. The full entry to find records with @ is Like "*@*"

Either way, whether you find the records with @ or the records without @ you are there clean up purposes.

 

[Mike375]

Adam,

He may end up needing Left and Right if he has any spaces followed by & "" &

 

[ajetrumpet]

I have no idea what he wants Mike, but you're probably leading him in the wrong direction like always...