Re: Standardize Address :: USPS
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62217
interpreted = N
texte = I want to standardize the addresses because when we process our credit card transactions, they need to be in standard form, or else the AVS code returned will say that the address is wrong. Regards, Ki Song ---------- Knifecenter, Inc. 5111 Berwyn Road STE 110 College Park, MD 20740 (301) 486-0901 ki@knifecenter.com > From: Donovan Brooke
> Reply-To: "WebDNA Talk" > Date: Tue, 14 Jun 2005 11:18:28 -0500 > To: "WebDNA Talk" > Subject: Re: Standardize Address :: USPS > > Ki Il Song wrote: > >> Is there a function built into WebDNA that would easily standardize U.S. >> Addresses on an order form? >> >> Or would I have to integrate the USPS Web API for Address Standardization? >> >> Ki Song > > > Ki, the USPS will get packages/letters to the right address even when > badly munged... However, if you wanted to standardize for your own > reasons, I would look at using a convert words database and maybe reference: > > http://www.usps.com/ncsc/lookups/usps_abbreviations.htm > (and other resources) > > So, you could do: > > **cnvt_wrds_db.db** > > FROMTO > avenueAve. > WiscansinWI > > (lol etc..) > > Then: > [convertwords db=cnvt_wrds_db.db][ShipToAddress1][/convertwords] > > Not sure of your reasons, but I probably wouldn't mess with it. > > HTH, Donovan > > -- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Euca Design Center > <-Web Development (specializing in eCommerce), -> > <- Graphic Design, Custom Tags and Labels -> > > ADDRESS:> Donovan Brooke > DBA Euca Design Center > 1871 HWY MM > Fitchburg, WI 53575 > PH:> 1.608.835.2476 > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I want to standardize the addresses because when we process our credit card transactions, they need to be in standard form, or else the AVS code returned will say that the address is wrong. Regards, Ki Song ---------- Knifecenter, Inc. 5111 Berwyn Road STE 110 College Park, MD 20740 (301) 486-0901 ki@knifecenter.com > From: Donovan Brooke > Reply-To: "WebDNA Talk" > Date: Tue, 14 Jun 2005 11:18:28 -0500 > To: "WebDNA Talk" > Subject: Re: Standardize Address :: USPS > > Ki Il Song wrote: > >> Is there a function built into WebDNA that would easily standardize U.S. >> Addresses on an order form? >> >> Or would I have to integrate the USPS Web API for Address Standardization? >> >> Ki Song > > > Ki, the USPS will get packages/letters to the right address even when > badly munged... However, if you wanted to standardize for your own > reasons, I would look at using a convert words database and maybe reference: > > http://www.usps.com/ncsc/lookups/usps_abbreviations.htm > (and other resources) > > So, you could do: > > **cnvt_wrds_db.db** > > FROMTO > avenueAve. > WiscansinWI > > (lol etc..) > > Then: > [convertwords db=cnvt_wrds_db.db][ShipToAddress1][/convertwords] > > Not sure of your reasons, but I probably wouldn't mess with it. > > HTH, Donovan > > -- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Euca Design Center > <-Web Development (specializing in eCommerce), -> > <- Graphic Design, Custom Tags and Labels -> > > ADDRESS:> Donovan Brooke > DBA Euca Design Center > 1871 HWY MM > Fitchburg, WI 53575 > PH:> 1.608.835.2476 > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Ki Il Song
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[search] in formulas.db (1997)
PCS Frames (1997)
Adding up line items. (2000)
Fwd: FW: Purchase Command error (1997)
Searching multiple fields from one form field (1997)
WebDNA deletes major DB data big time (2004)
RE: [WebDNA] SHA1 Encryption For WebDNA 6.2 (2013)
process SSI (1998)
Including a php script (2003)
Mozilla Firefox problem (2004)
autosensing lanague selection (1997)
searches with dash, period etc. (2000)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
Do the [date] thing... (2001)
Pull Down Search (2000)
Sorting Numbers (1997)
Forumulas.db & Variables (2002)
Signal Raised Error (1997)
Formating found categories (1997)
# of real domains on 1 web server (1997)