Extract discounts and retail prices from product descriptions

Budget €30 - €250 EUR
Bids 76
Average Bid €263
Status Closed

I need someone to extract some information (retail price, discount in percent, discount amount) from about 322,000 descriptions of products. For a part of the descriptions there is no information, for others only a part of it. The data can be provided in a csv or xls sheet (about 300MB). Please have a look at the examples!

Example 1:

"GET PETGUARD - ULTRA EARLY BIRD Get the best deal and help us kickstart Petguard! You'll receive one Sentinel and one Pet Tag - and you'll save $60 off the $179 retail price!"

Extracted information in new columns:

retail_price: 179

discount_amount: 60

discount_percent: (empty)

Example 1:


1 Blubel package in classic charcoal at over 23% discount to the retail price (saving of £15)"

Extracted information in new columns:

retail_price: (empty)

discount_amount: 15

discount_percent: 23

Get Free Quotes For A Project Like This

This project was awarded to


Easy to understand, started immediately and finished quickly. Tested it and the macro ran as asked and directed. Best experience ever and would definitely use him for future excel and/or vba projects!
About the Freelancer
macroPOL Profile Picture

I work every day with Excel: formulas and VBA. I specialize in: - Excel - Excel VBA - Excel automation - Data processing - Web scraping Have very successfully completed over 45 Freelancer projects with a 100% On-time, 100%Completed and 100% On-budget rating.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • tylene Profile Picture


    Male',  Maldives

    Cisco certified IT professional with 5 plus years experience in the IT field holding a Masters Degree in Computer Science.

  • TasnimEla Profile Picture


    213/5,Naozan Plaza,New Chaktai,  Bangladesh

    {{PERFECTIONIST}} {{POTENTIAL}} {{ENTHUSIASTIC}} Data Entry, Web research, Admin Support, Excel, Virtual Assistant. I am the person whom you are Looking for. I try my best to SIMPLIFY a job at your DESIRE LEVEL. My TARGET is CLIENT'S HAPPINESS. My POTENTIALITY is in work. GIVE UP and negetive thoughts is not in my Dictionary. I am BOUNDED to you till your SATISFACTION at a whole. I LOVE to work for my EXPERIENCE not MONEY. I HATE false PROMISES in working zone. I am available for 24/7 for work. I serve my 100% to a client till he/she is fulle satisfied. Fields Where I work to LOVE- 1. Virtual Assistance 2. Admin Support 3. Data Entry 4. Web Research 5. Email Leading 6. Data Processing 7. Data Mining You hire me for FAITHNESS not for MONEY. Your TRUST is my ACHIVEMENT.

  • Ibrahim185 Profile Picture


    Chittagong,  Bangladesh

    As a full-time freelancer, I have earned good reputation and a lot of positive feedback from our clients over the years.I have a team of dedicated professionals who are efficient, committed and hard working. ****HTML,CSS,JAVASCRIPT,JQUERY,PHP,MYSQL**** ✔ Zoomla, Magento,3d Cart, Wordpress, Ecommerce ,Ebay, Amazon etc. * Theme installation, customization, plugin development ✔ Facebook Likes+Facebook Comments+Facebook Shares+Facebook Photo Likes+Facebook Website Likes+Twitter Followers ✔ Photoshop, Illustrator, Coral draw, banner design, logo design, template design ✔ Data entry , data mining ,data processing, data analysis, product listing, excel, word, power-point, pdf editing etc. ✔ Search Engine Optimization with high PR , on-page , off-page ✔ Article writing, rewriting, submission, analysis ✔ Translation (Spanish, Dutch, German, Portuguese, Arabic, Bangla, English, French, Italian ) ✔ Email Template and so on. #Timely delivery #100% dedication #24/7 support

  • diamond247 Profile Picture


    Midnapore West,  India

    Diamond247 is a trusted name in freelancer, serving world class service since 2008. A competent team of experts for any: Web Search / Scraping "0R" Data Mining / Research, Need Merketing Leads? "0R" Manage your Product... Our experts will work as your "Virtual Assistant" to provide best service round the clock beyond your expectation. what special with us? [A team of skilled operator recommended by a lot of Employers.] [Complete 600+ projects successfully.] [During completing the amount of jobs gain a vast experience.] [A good number of rating for completing any jobs highlighted us ......among masses.] [ Understanding of projects, proper clearance from both our end as well as employer end before start a job.] This description is not enough for you if you are not tested us yet, check the sample of your job from us Get satisfied Lets start business with us............. :)

  • Sundaram87 Profile Picture


    Chennai,  India

    Have Consulting & Analytical Experience in various industry. Good Knowledge in Excel and Statistical Analysis. Experience in Data Cleaning, Data Analysis, MIS Preparation, Decision making Dashboards. Experience in IDEA and other Audit Tools. Expert Analytical Knowledge in following areas like Sales, Inventory, Purchase, Production, CRM and Finance.

  • bkar81 Profile Picture


    Chennai,  India

  • tasleem83 Profile Picture


    Lahore,  Pakistan

    I am a Data Entry/Data Processing Expert with years of experience. I know the value of time. I am very hard working and always deliver work on time. My motive is to make my employer Happy without additional charges. If you are looking for data entry work, I am the right person for you. I hope to deliver you the best of best services. Hire me to get the job Expertise:  Lead Generation (Email List Developing)  Web scraping and search (Extraction of data from websites and research)  PDF (Conversions to/from Ms Office, editing, forms etc.)  Ms Excel (reports, conversions etc.)  Ms Word (Formatting, renaming, conversions, graphs etc)  Data Processing (Data entry from websites, t etc.)  Ms PowerPoint (Presentations, conversions,)  Book Keeping  Transcription Services (Audio / video to text in word etc.)  Research (Financial and general research of information from internet etc.)  Problem Solving to general issues at work. Send me chat to discuss the

  • SarahFerns Profile Picture


    Mumbai,  India

    I am fully dedicated to work and have 5 years of experience in Data entry,Web Scraping,Excel and Copy typing.I respect client's values and time. I work with motivation and always meet deadlines. I never compromise on quality and give my 100% to the work.I am looking for a position that would recognize my talent and provide me an opportunity to put in my best for the benefit of the company.I would be happy if employed by you and will work to the best of my ability.

  • anachirilov7 Profile Picture


    Chisinau,  Moldova, Republic of

    I am capable of data typing, internet researching, and any administrative type of jobs. Also, I am knowledgeable on basic Microsoft Office- Word, Excel, and Power point application.

  • julioxtan Profile Picture


    Goicoechea,  Costa Rica

    Database management expert. +20 work experience. - PL SQL - Informix - MySQL - SQL Server - Pentaho - Excel - MS Access Microsoft certified systems engineer Linux: Cent OS, Red hat