-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > I would like all those on the same street grouped together. Is there any > tricks to getting the street names sorted first, possibly where numbers > and strings separate? As some have demonstrated, this can be a difficult problem. Your best bet is not to reinvent the wheel, but find someone who has already solved the problem. For example: http://search.cpan.org/dist/Lingua-EN-AddressParse/AddressParse.pm You could easily use the above in a Pl/perl function, or just in Perl if your application happens to be written in that. Worse case, check out the source code of the module and see how they have done it and create your own version. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200410290722 -----BEGIN PGP SIGNATURE----- iD8DBQFBgihdvJuQZxSWSsgRAvFBAKC1EcSW5Ru5+nZwNLenbRVqQlQP/wCgpvd6 TOiKff34E+DJVM7rcPkMACU= =55zK -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])