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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
