125366 Change output of CSV/XML file

This project was awarded to rajeshsonisl for $40 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required

Browse Related Skills

Related Projects

Other things people do on Freelancer

Latest Articles

Project Budget
Total Bids
Project Description

I have two product feeds available in CSV or XML. The 2 feeds contain [url removed, login to view] entries total.

The feed is currently set up like this:

Parure couette|"[url removed, login to view](1111111)p(222222)prod(90855383)"|"[url removed, login to view]"|"Parure couette ou drap. Endroit en 100% polyester jacquard

I want the output to be formatted like this:

Parure couette ** 0.1 ** [url removed, login to view](11111111)p(2222222)prod(90855383)epi(pf)

I want the results in Excel. There should be 5 columns per row:

Column 1: Parure couette

Column 2: **

Column 3: 0.1

Column 4: **

Column 5: [url removed, login to view](11111111)p(2222222)prod(90855383)epi(pf)

So what needs to be done?

1. Extract product title from the feed

2. Extract product URL from the feed

3. Delete all double entries (products with same product title)

4. Write to excel sheet in required format.

Looking to make some money?

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

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online