Re[4]: address parse

From: Robert Eskridge <bryny_at_dfweahs.net>
Date: Wed, 27 Feb 2002 06:33:24 -0800
Message-ID: <F001.00419A68.20020227063324@fatcity.com>

MTF> Robert must be new to the list. He is MUCH too nice. :)

Shhhhhhhhh! I'm playing good cop/bad cop...... :-)

-rje

MTF> -----Original Message-----
MTF> Sent: Tuesday, February 26, 2002 4:12 PM
MTF> To: Multiple recipients of list ORACLE-L

MTF> John,

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

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

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

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

MTF> AddressLine1
MTF> AddressLine2
MTF> City
MTF> State
MTF> Zip

MTF> When stating a parsing problem both the input form and the output form

MTF> need to specified. Also any peculiar rules. Above you'd need to MTF> state things like:

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

MTF> Now given all that, a parse routine could be written.  But lacking
MTF> such a specification, the question is very open for various

MTF> interpretation, any of which has only a remote chance of meeting your MTF> needs.

MTF> -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?

MTF> -rje

-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 Wed Feb 27 2002 - 08:33:24 CST