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]

On Sun, 22 Nov 2009 16:43:10 -0800, "Song Su" <son...@live.com> wrote:

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

--

John W. Vinson [MVP]

[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" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:ivnjg5taon599gv4e...@4ax.com...

[John W. Vinson]

On Sun, 22 Nov 2009 18:36:20 -0800, "Song Su" <son...@live.com> wrote:

>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([email], InStr([email], "@");

to group all the errors together.

Do note that .cn is a valid extension for addresses in China - I'm not sure
whether there is a yahoo.cn but I'd check before correcting it!