Jeramy:

   Unless you want to build some kind of business rules function, the only 
other option I see is for you to do a search and replace on the offending 
errors.  For example, I know of no legitimate reason for two dots in an 
email address right next to each other.  Nor do I know of a legitimate use 
for spaces in email addresses.  So either write a short Perl (or whatever) 
script to remove them, or do a manual search and replace in your favorite 
programming editor.  The latter, though not as elegant, would probably be 
the fastest.

R,

John A.M. Darnell
Project Leader
Internal Software Development
Walsworth Publishing Company
John may also be reached at johnamdarnell (at) gmail dot com

Trivia question:  The United Space Ship Enterprise's second captain was 
James T. Kirk.  Who was her first captain?  Extra credit:  What does the 
"T" in Kirk's name stand for?  The first captain (other than Robert April 
who served for a short time as Enterprise's captain during her shakedown 
cruise) to command Enterprise after its commissioning was Christopher 
Pike, played by Jeffrey Hunter in the dual episode entitled "Menagerie," 
which was cobbled together from scenes taken here and there from the 
pilot, called "The Cage."  The "T" in James "T." Kirk stands for 
"Tiberius."



Jeramey Valley <[log in to unmask]> 
Sent by: Macintosh Scripting Systems <[log in to unmask]>
12/04/2006 02:54 PM
Please respond to
Macintosh Scripting Systems <[log in to unmask]>


To
[log in to unmask]
cc

Subject
Verify email address formatting






I have a list of email addresses*. Some of the addresses in the list 
are not of correct form, meaning they may have a space, extra period 
or other no-no in the address.

Examples:

someDude@gmail..com
my name@my company.com

What's the best way to test and fix the errors in this list?

My plan was to use the regex function in the Satimage addition and 
perform a pattern replace. I would be creating the pattern from 
scratch.

Has anyone gone through and created the most common pattern matches 
they would like to share or have a better solution?

TIA

* addresses are parent email addresses provided to us by them on hard 
copy and then transcribed into a spreadsheet. It's all legit opt-in 
stuff.
-- 

Regards,

Jeramey Valley
[log in to unmask]
Network Services Manager
Midland Public Schools