clean up typos in domain part of email

[Song Su]

I want to clean emails before sending out. People have all kinds of typos in
domain part of email. Like following example, all should be @yahoo.com

What's the easy way to replace all the typos? If I can lean one, I can
handle other domains like @hotmail.com or @gmail.com Thank you for your
help.

@yahho.com
@yahhoo.com
@yahii.com
@yahioo.com
@yaho.com
@yahoo
@yahoo,com
@yahoo.,com
@yahoo..com
@yahoo.caom
@yahoo.cm
@yahoo.co
@yahoo.co,
@yahoo.com.
@yahoo.com.com
@yahoo.comcom
@yahoo.comi
@yahoo.comj
@yahoo.coml.com
@yahoo.comm
@yahoo.comnet
@yahoo.como
@yahoo.comom
@yahoo.con
@yahoo.conm
@yahoo.ocm
@yahoo.om
@yahooc.om
@yahoocom
@yahooio.com
@yahooo.com
@yahuho.com
@yahyoo.com
@yamail.com
@yamil.com
@yaoo.com
@yhaoo.com
@yhoo.com
@ymailcom
@yoahoo.cn
@yuahoo.com

 

[John W. Vinson]

I want to clean emails before sending out. People have all kinds of typos in
domain part of email. Like following example, all should be @yahoo.com

What's the easy way to replace all the typos? If I can lean one, I can
handle other domains like @hotmail.com or @gmail.com Thank you for your
help.

The trouble with making an application idiot proof is that the idiots are so
clever...

This will require a USB (Using Someone's Brain) interface. I would try a query
such as

LIKE "*@y*.*" AND NOT LIKE "*@yahoo.com"

but even that will find other ISP's which happen to start with y and will miss
some errors.

 

[Song Su]

That's a good starting point. It's only query possible error in domain part.
How to 'replace' those errors?

 

[John W. Vinson]

That's a good starting point. It's only query possible error in domain part.
How to 'replace' those errors?

Unless you have a list of all the errors, it's probably best to just do so
manually. Assuming that the field is called Email, try creating a Query such
as

SELECT tablename.Email
FROM tablename
WHERE Email LIKE "*@y*" AND EMAIL NOT LIKE "*@yahoo.com"
ORDER BY Mid((e-mail address removed)