Par2: Address Validaton 2007-09-25 -- Brett Carnaby This might give you a bit of a start.
Addrs_tmp FILE,DRIVER('BASIC','/ENDOFRECORD=1,10 /FILEBUFFERS=1
/QUICKSCAN=ON'),NAME(GLO:TempFile),CREATE,RECLAIM,PRE(DLF)
RECORD RECORD
Latitude STRING(32)
Longitude STRING(32)
Description STRING(256)
Original STRING(256)
Score STRING(32)
StreetNumber STRING(32)
Prefix STRING(10)
StreetName STRING(128)
StreetType STRING(20)
Suffix STRING(20)
City STRING(32)
State STRING(32)
ZipCode STRING(32)
END
END
DLAddrFile = GETTEMPFILENAME('')
AddrData = 'http://www.ontok.com/geocoder?key=key&fmt=CSV&q='
AddrData = Clip(AddrData) & Clip(PRP:Address)
AddrData = Clip(AddrData) & ' ' & CLIP(PRP:Address2)
IF CLIP(PRP:City) = ''
AddrData = Clip(AddrData) & ' ' & 'Indianapolis'
Else
AddrData = Clip(AddrData) & ' ' & CLIP(PRP:City)
End
IF CLIP(PRP:State) = ''
AddrData = Clip(AddrData) & ' ' & 'Indiana'
Else
AddrData = Clip(AddrData) & ' ' & CLIP(PRP:State)
END
AddrData = Clip(AddrData) & ' ' & CLIP(PRP:Zip)
x# = InetDownLoad(AddrData,DLAddrFile)
z# = UpdatePropertyAddressValidator()
Remove(DLAddrFile)
Printed May 4, 2024, 6:27 am This article has been viewed/printed 35125 times. |