Re: standard schemas for addresses, others?

On Thu, Jan 23, 2003 at 10:56:27AM -0800, Dennis Gearon wrote:
> Now THAT's a good idea, store a regex pattern for each country's zip code!

> 1/23/2003 10:01:19 AM, will trillich <will(at)serensoft(dot)com> wrote:
> > insert into nations ( abbr,name,zips )
> > values ( 'USA','United States of America','\\d\\d\\d\\d\\d(-\\d\\d\\d\\d)?' );
> > insert into nations ( by,abbr,name,zips )
> > values ( 'CANADA','Canada', '[A-Z]\\d[A-Z]\\s+\\d[A-Z]\\d' );

i only bother taking credit for ideas which don't seem obvious
to me. this one sure did.

i'll make an exception in this case. glad to have contributed!

:)

--
There are 10 kinds of people:
ones that get binary, and ones that don't.

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at http://clarkconnect.org/ !