PDA

View Full Version : What to do with horrendous CSV file you really need...


studioammo
10-23-2009, 05:31 PM
I really need this product catalog, BUT:


There are multiple sizes for brushes (art supplies) that have the same image, just different titles. (Is there a way to combine them?)

What do I do???

Here's a link to the csv file:

http://www.studioammo.com/datafeed/MisterArt.csv

ryan
10-23-2009, 09:19 PM
That's a tough one. The only way you could "combine" them would be by removing the brish sizes from the names and then using Excel to remove the duplicates. The manufacturer column seems to be unique for each product (regardless of brush/size); I'd suggest removing the duplicates based on that column.