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