Remove duplicates from a csv spreadsheet
- or -
Post a project like this4160
£40/hr(approx. $50/hr)
- Posted:
- Proposals: 42
- Remote
- #188028
- Completed
8972115706550434178858179029213992233799254993369658369485371748362311
Description
Experience Level: Expert
Hi, I have a excel spreadsheet which contains an export of data from my website.
I have a field in the spreadsheet which contains the image url's of products. If a product has multiple images the urls are in the same cell. My website uses the first url for the main image and the others for sub images.
example:
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580_ind.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580_ind.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090.jpg
ifyou break this down it looks like.
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580_ind.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580_ind.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090.jpg
I need:
A: The duplicate urls to be remove from each cell
B. The url to be flattened so it we're just left with the image filename and a comma to seperate.
In the above example we would just be left with:
02090_580_ind.jpg,02090_580.jpg,02090.jpg
Some cells/products have additional images some don't.
This job is ideal for a wizz at excel.
I have a field in the spreadsheet which contains the image url's of products. If a product has multiple images the urls are in the same cell. My website uses the first url for the main image and the others for sub images.
example:
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580_ind.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580_ind.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090.jpg,http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090.jpg
ifyou break this down it looks like.
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580_ind.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580_ind.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090_580.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090.jpg,
http://www.sweetswholesale.co.uk/media/catalog/product/0/2/02090.jpg
I need:
A: The duplicate urls to be remove from each cell
B. The url to be flattened so it we're just left with the image filename and a comma to seperate.
In the above example we would just be left with:
02090_580_ind.jpg,02090_580.jpg,02090.jpg
Some cells/products have additional images some don't.
This job is ideal for a wizz at excel.
Taz C.
93% (11)Projects Completed
13
Freelancers worked with
13
Projects awarded
35%
Last project
1 Feb 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies