DATA EXTRACTION - Superpages.com, etc.

I want to extract information based on specific categories from: [login to view URL] [login to view URL] [login to view URL] Under all categories (listed below), I would like to extract the following fields: See attachment: FORMAT Output should be Stored excel file or CSV Experienced coders only please. Quality of data is very important. If you are unsure of what I need Please ask any questions before you bid. After bid is finalize, I will need a sample of the first 200 records extracted put into an excel file with all fields to assure me that you are on the right track. In the Finished Product I will need: One master file = [login to view URL] File Broken Down by Category: sample; [login to view URL] , [login to view URL] etc. Platform: Windows, CSV for Excel CATEGORIES: See attachment REMOVE DUPLICATES Once all the data is extracted, go through existing data of all three sites combined and remove duplicates. Before removing duplicates, fill in all missing fields, like Missing fax , email or web etc, and keep one full record with the most information. Keep original category from superpages COUNTS We need counts of the records from the database by “category?? and “state?? in an excel sheet SPECIAL CODES All records which have the same address city st zip should have a code “SA?? All records which have the same phone number should have a code “ SP?? All records which have the same name should have a code “SN?? OTHER - Field Separator When there is a Dr First Name Last Name it should kept as extracted and also separated into columns By Fname, Lname, Title This is phase 1 of job, if work is completed satisfactorily, we will offer you a chance to work on phase 2. -------------------------------------------------------------------------------- ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows, CSV or Excel