125366 Change output of CSV/XML file

IN PROGRESS
Bids
1
Avg Bid (USD)
$40
Project Budget (USD)
N/A

Project Description:
I have two product feeds available in CSV or XML. The 2 feeds contain 107.000 entries total.

The feed is currently set up like this:

Parure couette|"http://pdt.xxxxxxxxxxxxxx.com/click?a(1111111)p(222222)prod(90855383)"|"http://www.xxxxxxx.com/bilder/a0001/210/4/40/40883500c00.jpg"|"Parure couette ou drap. Endroit en 100% polyester jacquard

I want the output to be formatted like this:

Parure couette ** 0.1 ** http://pdt.xxxxxxxxxxxxx.com/click?a(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: http://pdt.xxxxxxxxxxxxx.com/click?a(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.

Skills required:
Anything Goes, Data Entry, XML
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.