I need a script program that will extract owners name and address from homeowners database website using a unique property identifier , Assessor Parcel Number (APN).
The input data will be in an excel format, i would like the homeowners name and address in the spreadsheet format as indicated in the attached file.( Extractor [url removed, login to view])
The code must be commented so that it is clear how to modify the tool to deal with changes on the site. Preferably in Visual Basic.
Owners name must be divided into firstName, LastName and MiddleInitial/MiddleName and Suffix (e.g JR, SR, I, II, III etc), in case of multiple Owners the second owners name must also be divided up in the same manner.
The address must also be divided into address1, address2 (suite No), city, state and Zip.
The result that will be written to the same excel must include the full Owner's name (including second owner if present) in the same cell. This should be as obtained from the website results. This is in addition to the split names (firstname, lastname, middleinitial/name) for the first and second owners (if second owner exist) which should also be in the respective cells. Lastly the split address( Address1, address2,
city, state, and zip) should also be in the respective cells
Another condition is that if the owner is not an individual ( e.g an association, a bank, a company) this owner must not be divided up and it must go into a separate column name "Business Name". This condition should include all names that contain Inc. , LLC, Ltd, Trust, Trustee , Bank, Association , Co. and Company
At the end the resulting excel spreadsheet should have the following column headings:
(See attached file Extractor [url removed, login to view])
"Owners Full Name",
"First Owner's FirstName",
"First Owner's MiddleInitial",
"First Owner's LastName",
"First Owner Suffix",
"2nd Owner's FirstName",
"2nd Owner's MiddleInitial",
"2nd Owner's LastName",
"2nd Owner's Suffix",
Splitting of Address:
2820 E 6th St #130 Tucson, AZ 85716-5236
Address1: 2820 E 6th St
Splitting Owners Name:
BRONDT HAROLD A
?First Owner's FirstName?: HAROLD
?First Owner's LastName?: BRONDT
?First Owner's MiddleInitial?: A
These are all needed for the following counties:
Coconino: http ://[url removed, login to view]
The sample file sent to you contains data for more counties than the one above. As you successfully finish one county we can give you additional counties.