I have 3 files, An excel sheet, a txt file and a csv file (Can be opened via notepad)
The excel file contains all of the information. It has all medicines name. I have most of the names in the text files (About 14000 entries for both txt and csv files). There are about 8500 entries in the excel sheet. I need someone to take each entry from the excel file use the first column (Medicine name) and go into the category file first. Search in it if it already exists. It might be by a different name. So If it is change it to what ever it says in the excel file. If it is not available then add it into the files, search the web for the name of the medicine and find the category and generic name. The generic name can be what you find off the web and the category as well but for category you need to change it according to the existing ones in the file. Same for generic.
The files are in the following format:
Category , Medicine Name, Company.
Medicine Name, Generic Name, Company.
Entry# 3622 from excel sheet.
HYDRALAZINE 20MG ZAFA Pharmaceutical 24 1 40 Devices
The categories file has it under the Cardiovascular category.
This needs to be changed to:
Cardiovascular,HYDRALAZINE 20MG,ZAFA Pharmaceutical
The generic file has it as:
HYDRALAZINE,Hydralazine ,ZAFA Pharmaceutical
This needs to be changed to:
HYDRALAZINE,Hydralazine 20MG,ZAFA Pharmaceutical
This is a sample, most of them are already correct, or missing only a little infomation. The ones that are not already in the files, those need to be found via web. If category name on the website you searched is different then the ones available, use the most appropriate one from the existing categories.
Hello, I am interested in this job and available from now. I am able to do this job smartly. I will do it manually. So you will get an accurate result. You can know about me something in my website. Please check Plus
25 freelance font une offre moyenne de $106 pour ce travail
Hello, I am interested in this job.I can do it. Just I like to be hired to start. Thank you for your time, Arefin
Hi I am a data entry operator and a web searcher I will provide u fast and quality work looking for a long term relationship
i would like to bid on this project because this is what i do best. I am a data-entry specialist and familiar with medications since i am a registered nurse. I can assure accuracy at a limited time frame. Please feel f Plus
I have totally understood this task. I have do this task before. I have more experience with this. So message me for more details.
Hello ! I can create a script or program to perform the task. It is much easier and faster. Then I will research on the web for the needed information on the medicine name. I look forward working with you.
Very familiar with medicine registries as I had created a database myself. Also I am a Physician, thus having extensive knowledge regarding medication.
I work with computers everyday at my day job and have recently been learning a lot about excel. I feel I could do this quickly and effectively using excel formulas. I also work in a bank where our error rate is less Plus
dear, i read your requirement very carefully, i have experience in wordpress. so i need more discussion on this project. with regards jasmeet kalsi
Hi, I've gone through the project details, and understand what you are trying to achieve. I'd like to speak with you to confirm project. Thanks