Completed

Scrape data from Documents on internet and put data into excel file

I need to scrape data from the documents show at the links in column F of the attached spreadsheet. There is specific data from the documents that I need to display in the columns N and higher. I have attached scans of documents with the information that I need highlighted/circled and the field name of the column header that I want at the top of the column with the corresponding highlighted/circled data.

Some of the fields may not appear on every document. For example, "Right of Redemption" is not on the first 2 documents that I scanned, but it does appear on the 3rd. If the phrase "This property will be sold subject to the 120 day right of redemption of the United States of America," the data I need in excel is only "120" in the "right of redemption" column.

For the "Interim Interest" column, if the document contains "The successful bidder must pay interim interest from the date of sale through date of compliance at the rate of 6.25%." I only need "6.25%" to be displayed in the "Interim Interest" column.

For the "Deficiency date" and "deficiency days" columns, if the document contains "Bidding will not remain open after the sale," I need "NA" to display in columns R and S. If the document contains "Bidding will not close on the sales day, but will remain open for a period of 30 days to close on 7/2/2014," .... (days and date could be different values than this example). I need "30" to display in column R and 7/2/2014 to display in column S.

For the "Encumbrances" column (P), I need the text that appears after the ":". For example, If the document contains the text "This property will be sold subject to the following mortgage(s)/senior encumbrances: None," I need "None" to display in column P. In the third document I scanned, I need "from the date of the sale afforded the United States of America pursuant to 28 U.S.C.A 2410(c)." displayed in column P.

Let me know your thoughts and questions. Thanks.

Skills: Data Processing, Database Programming, PHP, Software Architecture, Web Scraping

See more: Mortgage sales, Interim sales, scrape for links, scanned documents, data into r, excel mortgage, scrape property, excel columns header name, highlighted attached document, mortgage excel, sales data excel file, excel specific data, scrape links, senior need data, excel file states, states excel file, data senior, excel spreadsheet united states, excel spreadsheet states, links scrape

About the Employer:
( 20 reviews ) Duncan, United States

Project ID: #7353361

Awarded to:

PigtailXL

Hello Sr. I've read the attached PDF file with 3 pages (as as a sample) and it's totally possible to do it. I'd like to discuss with you more in detail some project details, like the price, timeline and mainly, h More

$222 USD in 10 days
(22 Reviews)
4.7

11 freelancers are bidding on average $283 for this job

rajeshsonisl

Hello! With 99% completion rate, 750 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u More

$473 USD in 3 days
(545 Reviews)
7.6
mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$250 USD in 5 days
(224 Reviews)
7.1
webscrapinggurus

Hello, we are the number one provider of business data(name, contact, category, !! E-Mail !!, etc). You supply the location and business keywords and our bot searches Google Maps, and other sources for related busin More

$526 USD in 45 days
(61 Reviews)
7.0
jhliuster

Hi sir I'm professional web data extractor, is all the data you need from PDF file? do you have a Excel template? how many data are there? I want to get more details about this project, wait for your reply, thanks. More

$222 USD in 3 days
(134 Reviews)
6.6
phpXpertbd

Dear Sir, I'm very much delighted to let you know that i did data scraping with PHP-cURL, Node.js, Selenium from many sites. I just scraped the data from web site and then wrote the data in mysql database or excel o More

$250 USD in 3 days
(36 Reviews)
6.3
weblazer

Good day! Im very interested to do this project. I worked as admin support for almost four years in one of the outsourcing company here in the Philippines. I did similar to this project and the client was very happy wi More

$200 USD in 3 days
(34 Reviews)
6.0
profesional2020

Hello, This is William and I represent Plestar interactive. Plestar interactive is a registered private limited organization based at Chennai, India. We offer services on BPO, KPO and Online Marketing, website develop More

$444 USD in 7 days
(5 Reviews)
4.7
fah15

"I NEVER BID ON PROJECTS, WHICH I AM NOT BEEN ABLE TO COMPLETE" I can get this done from a professional Excel user, who works whole day on excel in his firm (PWC) Do let me know if you want to get it done from an Ac More

$250 USD in 5 days
(17 Reviews)
4.3
vcare77

Dear Hiring Manager, More

$222 USD in 3 days
(17 Reviews)
4.3
radubran

A proposal has not yet been provided

$55 USD in 1 day
(20 Reviews)
3.9