In Progress

125366 Change output of CSV/XML file

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.

Skills: Anything Goes, Data Entry, XML

See more: double data entry excel, xml excel, xml data entry, change url, feed data xml, extract product data csv, csv feed url, xml excel format, excel required csv, csv column format, excel delete row, change column, xml file excel, write file excel, excel change data format, xml feeds product, csv product, xml feed excel, feed file, xml feed url, 107, excel data jpg, csv feed, extract products, data entry jpg excel

About the Employer:
( 30 reviews ) Dresden, Germany

Project ID: #1871532

Awarded to:

rajeshsonisl

Right away.

$40 USD in 0 days
(543 Reviews)
7.2