Login
`
Templates, Tools and Utilities
|
||
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link 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)
Today is November 21, 2024, 7:00 am This article has been viewed 35234 times.
|
|