Closed

extract data from web database and paste it to excel - Repost - open to bidding

I want the terms to be searched in the expert search field on www.clinicaltrials.gov. This expert search is difficult to find: first go to advanced search, type in anything, click on search, then click on modify the search results. You'll find the link for expert search in the upper right part of the website.

Expert search is characterized by a large search field...

Just delete the prior search string and copy & paste the search strings from the attached excel file (input data sheet). There are about 500 search strings of them. There is no data for every year, as you'll notice.

Then please download the entire results list. You'll find the download link above the results list.

I want to have all 21 data fields.

Select the number of studies to download: click on the option at the bottom of the dropdown menu, where you'll find the number of total hits.

There are multiple download formats. Please choose comma-separated (csv) and xml). I want to have XML as a backup, only csv shall be processed. Please name the downloaded xml files as follows:

Combination of firmname from column A and year from line 1 (years 2003-2010),

(what you'll do with csv depends on you - if you directly extract the content, then it's fine. If you prefer to download all files first, then please make sure that you name them properly!)

I want the data to be in columns as with the csv files.

Then I want the data to be in the following format:

Column A contains the firm name, column B contains the year (2003-2010). Columns C, D, E.... are the data you downloaded.

Please have a look at the example which, at the same time, is the file to be completed...

Just in case there should be too many entry terms in the first field (where you get an error message), please proceed with the others and notify me.

You may notice that the data is somewhat overlapping (actually I look for 2001-2003, 2002-2004, 2003-2005, so entries for years 2003 appear three times - that's correct).

Summarizing:

Go to that website and use the expert search

Copy the search terms for the companies and year listed in the attached excel file (input data sheet) and paste them to the web database search field.

Then download the files (csv + xml) for ALL hits and ALL fields (attention, you may forget to adjust that when you download hundreds of files).

Open the csv file, copy its content and paste it to the file (results sheet) that I attached.

Rename the xml files as described.

Finally, please provide the excel file plus the xml files (the latter all inside one or a few ZIP files).

Please provide an estimate how many hours you'll need and on which day you'll be able to complete the task.

Thank you very much.

Skills: Data Entry, Excel

See more: where to find xml files, what is search string, web content companies, to advanced, string c plus plus, search files on web, overlapping line, open 2005, how to get website hits, how to get web hits, how to get hits on website, how to get hits on a website, how to expert in excel, how to be an expert on excel, how to be an expert in excel, how to be an excel expert, get web hits, formats in excel, find an excel expert, extract number from string, excel advanced 2010, excel 2010 advanced, c plus plus string, be an expert in excel, advanced excel website

About the Employer:
( 0 reviews ) United States

Project ID: #5817463

18 freelancers are bidding on average $4/hour for this job

diamond247

Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill,have complete more than 200 similar job, i have gone through your project description, its really a More

$2 USD / hour
(106 Reviews)
6.7
YourAssistant

Hi, I would be glad of having the opportunity to work on this project. I have read your job specifications carefully; please let me let you know that I have 15+ years of experience in this kind of work Please notic More

$5 USD / hour
(110 Reviews)
6.1
mindware97

Hi there Your project posting really excites me as I am doing similar job. I am a freelancer with 6+ years of experience in freelancing. I have worked on more than 141 freelancing projects (data entry, technica More

$5 USD / hour
(15 Reviews)
4.5
ajharul

Dear hiring manager, Thank you for this wonderful opportunity. Your job post has caught my attention because I'm a web-research addict and I’m considering your job post for me with the required capabilities. I ha More

$3 USD / hour
(7 Reviews)
2.8
vcare77

Dear Hiring Manager, I can do this job efficiently and effectively Have a great day to you, I am interested to do this job and please see my elance profile link https More

$3 USD / hour
(7 Reviews)
2.3
vater

Dear Sir, We would like to take up this project right away. Please award the bid for us to provide a prompt and accurate solution. We also offer you in - depth QC process and would scale up our quality to exceed your More

$3 USD / hour
(1 Review)
1.2
juliepearlyana

Hello and have a good day! I very very interested to work in your posted job with all my knowledge, skills and ability can assure to attain good quality results. I understand what you need and I'm offer my services More

$2 USD / hour
(2 Reviews)
0.6
Rajeev06

Talk with me I will do this job for you. I can do this job for you. Talk with me I will do this job for you. I can do this job for you.

$2 USD / hour
(1 Review)
0.0
EssieV9

Hello, I would like to work on this project May be my bid low compare to other but it will not affected on work. I can start work immediately and provide you within time frame. I have more than 6 yr experience i More

$2 USD / hour
(1 Review)
0.0
adyclaudiu

I can do the work you require accurately. I am very careful with details, I take my job very seriously. I am a new freelancer on this site and I want to create a great and long time relationship with my clients. I More

$3 USD / hour
(0 Reviews)
0.0
lusnyak123

Hi fotso 94, My name is Lusine. I am ready to to this task and finish it on time. I can start the work immediately. Thanks, Lusine

$2 USD / hour
(0 Reviews)
0.0
ramimallek

Aucune proposition n'a encore été fournie.

$2 USD / hour
(0 Reviews)
0.0
sanboy145

HI there, I am a Bioinformatician. I guess i can do your work efficiently. I'll be available on all weekdays from 10.00 pm to 12 pm (Indian Standard Time) and for longer hours on weekends. I am good at such tasks. More

$5 USD / hour
(0 Reviews)
0.0
benitamal6

I have experience in automation website extraction and i can give u seperate tool after finishing this project for you at affordable cost so that u can use it when ever u want to . Please let me know if you are interes More

$11 USD / hour
(0 Reviews)
0.0
phpdiwakar

I am interested in doing this project. I have done php , cakephp, c++, html, css , jquery, ajax, wordpress and have a good knowloedge about ms office.

$2 USD / hour
(0 Reviews)
0.0
SAMsam1234

i have made many projects on excel and i m also making site including daatabase .i m interedted in this feild of devolepmnt hope you will like my work if u hire me thanks

$5 USD / hour
(0 Reviews)
0.0
DesignerChintan

Hello Hiring Manager, I have expertise in Web Design,Web development,Software Development And Mobile Application.I believe that work is first and for that i give full dedication to my work and complete as per requi More

$8 USD / hour
(0 Reviews)
0.0
s1365285

Hi. I think it's an easy job but has some details. I can work for 10 hours per week on this project. I'll work every day of week. There is no limitation. If I want to tell you an estimate how many hours I'll need, I sh More

$4 USD / hour
(0 Reviews)
0.0