That's pretty clever! Our SIG enjoyed a presentation from Ed Hardin - he demoed with IE automation and a ShellScript routine.

It doesn't seem like to had to parse through HTML tags to get to the data. It seems your routine is fairly confident that the offsets at '901' will produce the data as advertised.

You should write an article for us. Thank's for the insight on how to scrub the whitepages:) I hadn't seen that one yet. Coooooool - especially for a cop and a repub - you have broke the mold!:-)

>>>Hmmm, download voter registration? Not aware of that. Off duty policemen can do anything they want within the law. I already had the voter registration file, which was purchased by a candidate. Try again.<g>
>>
>>And your not comparing to to confidential info in the DMV database or other taxpayer owned databases? (is this a good try:-)
>
>Nope passing the address to a webpage and parseing the returning html.
>
>Heck, it ain't rocket science so here's the gist of it:
>

>lcurl=[http://www.whitepages.com/10692/search/Reverse_Address?housenumber=]+ALLTRIM(m.house_num)+[&street=]+ALLTRIM(m.vstrname)+[&city_zip=bartlett&state_id=TN]
>oie.Navigate(lcurl)
>
>DO WHILE oie.readystate<>4
>enddo
>DO WHILE oie.document.readystate<>'complete'
>enddo
>lc=oie.document.body.innertext
>IF OCCURS('901)',lc)>0
>m.phone= SUBSTR(lc,AT('901',lc)+5,8)
>?M.PHONE+' '+ALLTRIM(first_name)+' '+ALLTRIM(LAST_NAME)
>GATHER MEMVAR FIELD PHONE
>ENDIF
>RETURN m.phone
>