Đã hoàn thành

132542 Scripts for Data Extraction

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])

"Business Name",

"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

Address2: #130

City: Tucson

State: AZ

Zip: 85716-5236

Splitting Owners Name:


?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.

Kĩ năng: Bất kì công việc gì, Visual Basic

Xem nhiều hơn: website data extraction tool, visual basic for website, st bank, i parcel, first county bank, business owners database, excel split a cell, unique name for website company, sr, separate data in spreadsheet cell, parcel, jr, input data , GIS MAP , gis data, extract map, database extraction, data visual, data extractor, data extraction and input, az, sample data input, excel database visual basic, cell names, visual basic database excel database

Về Bên Thuê:
( 7 nhận xét ) Lagos, Nigeria

ID dự án: #1878713

Được trao cho:

$120 USD trong 3 ngày
(0 Đánh Giá)