Re: [IUG] Regular Expression for bad email addresses

["Boggs, John" <boggs at plsinfo dot org>]

Responding to my own request here, with an update.

I've tested these expressions on exported email address fields using
egrep, and they work as expected.  So I guess the question is why don't
they work in Create Lists?

Unless anybody here knows something that would explain why these
expressions won't work in Millennium, I think it's time for another call
to the help desk...

John D. Boggs, PLAN Database Manager
Peninsula Library System
2471 Flores Street
San Mateo, CA  94403-2273
(650)571-6799 x3062
boggs at plsinfo dot org

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Boggs, John
Sent: Monday, June 09, 2008 4:13 PM
To: IUG INNOPAC List
Subject: [IUG] Regular Expression for bad email addresses

I'm working on a regular expression in Create Lists, and it's not
behaving how I expect it to.  I'm not sure who's having the brain-dead
moment:  Me or Millennium.

 

I'm looking for email addresses that don't have either a 2 or three
character extension.  (.com, .edu, .tv)  I came up with the following:

 

PATRON  Email  matches  "[^.]...$"    AND PATRON  Email  matches
"[^.]..$"

 

My expectation was any email address with 4 non-dot characters at the
end would show up.  I did get .coom and such, but I also got plenty of
.com and .edu addresses.  So I added <space>* to the end of my
expressions, thinking that if there were spaces there that might be
messing up my search.  No luck - I got the same set.

 

I also just now tried [^.]{4}$, and I get even *more* perfectly fine
addresses, that do have a dot within the last 4 characters.

 

Am I missing something in my expressions?  Or is Millennium not parsing
my expression properly?  (Or maybe there's data stored at the end of the
field that we can't see...)

 

Thanks for any insight!  I'm stumped today.

 

John D. Boggs, PLAN Database Manager
Peninsula Library System
2471 Flores Street
San Mateo, CA  94403-2273
(650)571-6799 x3062
boggs at plsinfo dot org <blocked::mailto:boggs at plsinfo dot org> 



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---
--
This message was distributed through the Innovative Users Group INNOPAC
list
Public replies:  INNOPAC at innopacusers dot org
Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac