Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: address parse
Robert must be new to the list. He is MUCH too nice. :)
-----Original Message-----
Sent: Tuesday, February 26, 2002 4:12 PM
To: Multiple recipients of list ORACLE-L
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 writtenS> that
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 - 07:18:21 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message