Oracle-L: RE: Re[2]: address parse

From: Mercadante, Thomas F <Thomas.Mercadante_at_Labor.State.Ny.Us>
Date: Wed, 27 Feb 2002 05:23:24 -0800
Message-ID: <F001.0041992C.20020227052324@fatcity.com>

But Ron,

what is the IRS gonna do if you report all address's in a standard way?

throw the form away?
return it and say it's invalid?
fine the company?

or just accept it and go on. let's just guess which one.....

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

Sent: Wednesday, February 27, 2002 7:33 AM To: Multiple recipients of list ORACLE-L

To throw a totally different twist into the combination: The new IRS ( yer favorite U.S. institution) form for corporations to report taxable income for individuals requires--- 1.If the address of the individual is in the U.S. use the street1,street1,city,county,state,zip fields. 2.If the address of the individual is outside the U.S. place all the information into 1 field.
makes for a nightmare to parse the information. ROR mª¿ªm

>>> bryny_at_dfweahs.net 02/26/02 04:12PM >>> 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).
--

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

Author: Ron Rogers
INET: RROGERS_at_galottery.org

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

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