how to make json object from an element in json object with unique values in underscore js

Question

I have a json Object as below

[
    {
        "MerchantName": "Fashion and You",
        "BrandList": " Nike, Fila",
        "MerchantImage": "Fashion-You-medium.jpeg"
    },
    {
        "MerchantName": "Fashion and You",
        "BrandList": " Levis, Fasttrack, Fila",
        "MerchantImage": "Fashion-You-medium.jpeg"
    },
    {
        "MerchantName": "ebay",
        "BrandList": "Nokia,HTC,Samsung",
        "MerchantImage": "ebay.jpeg"
    },
    {
        "MerchantName": "amazon",
        "BrandList": "Apple,Dell,Samsung",
        "MerchantImage": "amazon.jpeg"
    },
    {
        "MerchantName": "amazon",
        "BrandList": " pepe jeans, peter england, red tape",
        "MerchantImage, Fila": "amazon.jpeg"
    }
]

I need to make a json object with Unique BrandList as below in underscore.

[{"Nike"}, {"Fila"},{"Levis"}, {"Fasttrack"},{"Nokia"}, {"HTC"},{"Samsung"}, {"pepe jeans"}, {"peter england"},{"red tape"}]

Can i get the data as below instead of the above format, and the brand must be unique.

 brands = [{brand:"Nike",status:false},  {brand:"Fila",status:false}, {brand:"Levis",status:false},{brand:"Fasttrack",status:false}, {brand:"Nokia",status:false},{brand:"HTC",status:false}, {brand:"Samsung",status:false} ]

This is really easy to do with _.pluck() - look it up in the Underscore docs — Bojangles
– Bojangles, Commented Aug 25, 2013 at 8:39
Is your question really about JSON or about processing the data in JavaScript? Also note that your desired result is not valid JSON. — Felix Kling
– Felix Kling, Commented Aug 25, 2013 at 8:42
when i use _.pluck() im getting data as [" Nike, Fila", " Levis, Fasttrack, Fila"] — nikhil reddy
– nikhil reddy, Commented Aug 25, 2013 at 8:49

Nikolai Borisik · Accepted Answer · 2013-08-28 05:56:40Z

1

var col = [
    {
        "MerchantName": "Fashion and You",
        "BrandList": " Nike, Fila",
        "MerchantImage": "Fashion-You-medium.jpeg"
    },
    {
        "MerchantName": "Fashion and You",
        "BrandList": " Levis, Fasttrack, Fila",
        "MerchantImage": "Fashion-You-medium.jpeg"
    },
    {
        "MerchantName": "ebay",
        "BrandList": "Nokia,HTC,Samsung",
        "MerchantImage": "ebay.jpeg"
    },
    {
        "MerchantName": "amazon",
        "BrandList": "Apple,Dell,Samsung",
        "MerchantImage": "amazon.jpeg"
    },
    {
        "MerchantName": "amazon",
        "BrandList": " pepe jeans, peter england, red tape",
        "MerchantImage, Fila": "amazon.jpeg"
    }
];

var brands = [];
//get unique brands
_.each(col, function(i){
   brands = _.union(brands,i.BrandList.split(','));
});

//build output
brands = _.map(brands, function(brand){
    return { brand : brand, status : false};
});
console.log(brands);

//if you need json output
var brandsJson = JSON.stringify(brands);
console.log(brandsJson);

Source code http://jsfiddle.net/DvnvN/

edited Aug 28, 2013 at 5:56

answered Aug 25, 2013 at 9:02

Nikolai Borisik

1,51113 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nikolai Borisik Over a year ago

I don't see way to do this without looping.

Felix Kling Over a year ago

@nikhilreddy: Note that Nikolai used an array of objects as example. If you get your data as JSON, you have to parse it first (JSON.parse), apply the code to the result (an array of objects) and then convert it back to JSON with JSON.stringify.

ne8il · Accepted Answer · 2013-08-26 00:15:44Z

As noted the json object you listed is not valid. If you are looking for a way to populate an array of just unique brand names, you can use a few underscore functions -

var arr = ...;

function trim(str){
    return str.replace(/^\s+|\s+$/g, "");
}

var mapped = _.map(_.pluck(arr, 'BrandList'), function(type){
  return _.map(type.split(","), function(brand){
    return trim(brand);
  });
});

var unique = _.uniq(_.flatten(mapped));
//outputs ["Nike", "Fila", "Levis", "Fasttrack", "Nokia", "HTC", "Samsung", "Apple", "Dell", "pepe jeans", "peter england", "red tape"]

http://jsbin.com/eTIPoyU/1/

I'm not sure this is any easier to read then a simple loop and it creates several intermediate arrays in the process, but it gets the job done.

Collectives™ on Stack Overflow

how to make json object from an element in json object with unique values in underscore js

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related