Re[2]: address parse

From: Robert Eskridge <bryny_at_dfweahs.net>
Date: Tue, 26 Feb 2002 13:12:10 -0800
Message-ID: <F001.00419191.20020226131210@fatcity.com>

John,

We're actually messing with you a little bit, having fun at your incomplete question. Not only are there many things that could be considered an address, some of them have several components that could be combined in several different ways. Not only that, but there are different ways that you might choose to represent those components.

A common street address example would be that given something like:

'1293 Incomplete Drive, Suite 2001, Mail Stop H, Specification City, Oklahoma, 74953-0011'

And a common set of fields to parse it into would be:

AddressLine1
AddressLine2
City
State
Zip

When stating a parsing problem both the input form and the output form need to specified. Also any peculiar rules. Above you'd need to state things like:

-Assume USA address
-Comma separated fields
-City state and zip are last three fields
-First field always AddressLine1
-If 4 fields AddressLine2 left null
-If 5 fields then field 2 is AddressLine2
-If 6 or more fields, then fields 2 - (n-3) are concatenated separated
by commas in AddressLine2
-State will be stored as 2 character state code
-Zip can be either 5 digit or 9 digit (no dash) codes

Now given all that, a parse routine could be written. But lacking such a specification, the question is very open for various interpretation, any of which has only a remote chance of meeting your needs.

-rje

S> street address

S> -----Original Message-----
S> Sent: Tuesday, February 26, 2002 10:55 AM
S> To: Multiple recipients of list ORACLE-L


S>> Anybody already have an address string parser (plsql) already written

S> that
S>> they would care to share?

S> Address? IP? Internet mail? USPS? Memory address? URL?

-rje

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Robert Eskridge
  INET: bryny_at_dfweahs.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 26 2002 - 15:12:10 CST