[RBASE-L] - RE: Address checker broken

[Kramer, Jason J]

                I know this is an older message, but I was working on another 
project and am just getting to some older email.
                You can check address directly on the Post Office website.  I 
use a macro that runs in iMacros (http://www.iopus.com/).  It reads a CSV file 
of address and then returns a valid address, or an error for an address that 
can't be found, to another CSV file.  This is not a 100% automated solution, 
but with some work it could be.  The macro I use is below.
                                                                                
Thanks,
                                                                                
Jason

VERSION BUILD=9002379
SET !DATASOURCE Seating.csv
SET !DATASOURCE_COLUMNS 9
SET !DATASOURCE_LINE {{!LOOP}}
SET !EXTRACT_TEST_POPUP NO
'FILEDELETE NAME=C:\RBMacros\Results\FinalAddress.CSV
WAIT SECONDS=5
URL 
GOTO=https://tools.usps.com/go/ZipLookupResultsAction!input.action?resultMode=0&companyName=&address1={{!COL3}}&address2={{!COL4}}&city={{!COL5}}&state={{!COL6}}Y&urbanCode=&postalCode=&zip={{!COL7}}

TAG POS=1 TYPE=SPAN FORM=NAME:ship-to-address ATTR=CLASS:address1<SP>range 
EXTRACT=TXT
SET !VAR1 {{!EXTRACT}}
SET !EXTRACT NULL
TAG POS=1 TYPE=SPAN FORM=NAME:ship-to-address ATTR=CLASS:city<SP>range 
EXTRACT=TXT
SET !VAR2 {{!EXTRACT}}
SET !EXTRACT NULL
TAG POS=1 TYPE=SPAN FORM=NAME:ship-to-address ATTR=CLASS:state<SP>range 
EXTRACT=TXT
SET !VAR3 {{!EXTRACT}}
SET !EXTRACT NULL
TAG POS=1 TYPE=SPAN FORM=NAME:ship-to-address ATTR=CLASS:zip EXTRACT=TXT
SET !VAR4 {{!EXTRACT}}
SET !EXTRACT NULL
TAG POS=1 TYPE=SPAN FORM=NAME:ship-to-address ATTR=CLASS:zip4 EXTRACT=TXT
ADD !VAR4 -
ADD !VAR4 {{!EXTRACT}}

SET !EXTRACT {{!COL1}}
ADD !EXTRACT {{!COL2}}
ADD !EXTRACT {{!VAR1}}
ADD !EXTRACT {{!VAR2}}
ADD !EXTRACT {{!VAR3}}
ADD !EXTRACT {{!VAR4}}
ADD !EXTRACT {{!COL8}}
ADD !EXTRACT {{!COL9}}

SAVEAS TYPE=EXTRACT FOLDER=C:\RBMacros\Results FILE=FinalAddress.CSV

Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of mike epstein 
sony viao office
Sent: Sunday, June 02, 2013 11:59 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Address checker broken

Good morning


I have used a program to find zipcodes by address for 5 or 6 years it was/is 
called address checker.  I have used it in an eep that captured the street 
address and returned the proper name and zipcode. I actually learned of the 
program through the rbase list . It seems that the program addrchek.exe does 
not work anymore.
I was wondering if anyone has another option ?

Mike Epstein