Closed

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:
( 0 reviews ) India

Project ID: #7402018

15 freelancers are bidding on average $152 for this job

PigtailXL

Sr, I have developed a solution for this file. Contact me to discuss the details. I will not accept the project before to discuss with you all the details. Thanks.

$35 USD in 1 day
(185 Reviews)
7.2
rkmomin

Dear Hiring Manager, The QUALITY of our work speaks for itself, and the fact that our company has grown exponentially since it's formation in November 2013 is a testimony to our work ethic. Here are links of our More

$100 USD in 3 days
(150 Reviews)
7.0
jayamsoft

Hi, We are experienced programmer with more than 4 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases lik More

$155 USD in 4 days
(15 Reviews)
5.5
kng229

I have a lot of experience with web scraping for my job, and one of my common tasks is very similar to your issue. Each day, I have to scrape data from an antiquated web-based application system for my employer. The More

$111 USD in 3 days
(8 Reviews)
5.8
vbexcel

I am a web scraper professional with over ten years experience. I can provide with many reference projects on your requ In order to confirm my cost and delivery I would need to review your spreadsheet. Regards Ze More

$100 USD in 3 days
(20 Reviews)
5.0
prabakarm23

Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv More

$222 USD in 3 days
(39 Reviews)
4.7
binarycodersvw

Hi.I have read the description of your project and I am [login to view URL] name is Andrei. I am a Visual Basic .NET programmer and website developer with 10 years experience. I know you hear things like these a lot but I ca More

$211 USD in 7 days
(16 Reviews)
4.4
vsprybhanu

Hi, Experienced Web Scraping, Excel VBA, VB6 and VB.Net Programmer. Expertise in MS Excel, Access and Visual Basic Programming. Read and understood your project description. I've excellent knowledge of More

$200 USD in 10 days
(26 Reviews)
4.2
marcovallerga

Non hai ancora fornito una proposta

$222 USD in 5 days
(1 Review)
1.2
Olouge

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
techomaxsolution

Hi Sir, We have dedicated center running for Software development and BPO processes. We have experience resources on SQL,MYSQL,HTML5,Hadoop. We are very much interested in this [login to view URL] can test our capabilit More

$155 USD in 3 days
(0 Reviews)
0.0
RomanKotliarov

Hi! i'm sure what i can make a lot of work for you. 70% of my job are the same job and the same sites, but here i'm a newcomer. contact me please, and you will not regret.

$155 USD in 3 days
(0 Reviews)
0.0
nuwantharanga63

Sir, I have enough time to spend infront of computer. But not for playing games . i want to get some advantage from rather than the [login to view URL] i think this would be the great opportunity for me to serve you in the More

$155 USD in 3 days
(0 Reviews)
0.0
hyounes

I have a great and long experience on Excel, can definitely help you on this project. Not everybody has this ability of working on such a great tool. Hope we can work together, Cheers

$155 USD in 3 days
(0 Reviews)
0.0
scorpiofas007

I am currently working as Medical Transcriptionist, therefore my typing speed is very good, so there will not be any issue to full fill your requirement within the time frame.

$155 USD in 3 days
(0 Reviews)
0.0