How to iterate through variable of variable provided in array in jquery?

Question

var data1: [{
    {
        postalcode:'qwerty',
        cT: 23,
        latitude:57.232324,
        longitude: -2.343543,
        call_reason: 'xyz',
        Call_Sub_reason:'abc'
    },
    {
        postalcode:'qwerty1',
        cT: 43,
        latitude:57.223524,
        longitude: -1.435453,
        call_reason: 'xyz1',
        Call_Sub_reason:'abc1'
    },
    .
    .
    .
    {
    .
    .
    }
}];

want data in this format:

var data1 : [{
    {
        postalcode:'qwerty',
        cT: 23,
        location:[57.232324,-2.343543],
        call_reason: 'xyz',
        Call_Sub_reason:'abc'
    },

    {
        postalcode:'qwerty1',
        cT: 65,
        location:[58.232324,-1.343543],
        call_reason: 'xyz1',
        Call_Sub_reason:'abc1'
    },

    {
    .
    .
    }
}];

If my data is in this format in database and I want data in the following mentioned type .. how can I get it? — Hetaxi Patel
– Hetaxi Patel, Commented Oct 11, 2018 at 8:35
The data format you provided is not correct, and wait a minute, are both format same ? I mean, you provided one format and expected it in the same format ? — Towkir
– Towkir, Commented Oct 11, 2018 at 8:37
As above: [{{ is how your JSON starts, that is invalid syntax. Also, keys should be quoted and double quotes should be used, not single quotes. — BritishWerewolf
– BritishWerewolf, Commented Oct 11, 2018 at 8:38
@Towkir A new key is used, which is a concatenation of longitude and latitude. — BritishWerewolf
– BritishWerewolf, Commented Oct 11, 2018 at 8:39

Adrian · Accepted Answer · 2018-10-11 09:06:46Z

2

You can use the following (given you fix the syntax issue in your JSON response):

var formatted = data1.map(x => {
    var xy = Object.assign({}, x);

    xy.location = [xy.latitude, xy.longitude]
    delete xy.latitude;
    delete xy.longitude;

    return xy;
});

var items = [{ postalcode:'qwerty', cT: 23, latitude:57.232324, longitude: -2.343543, call_reason: 'xyz', Call_Sub_reason:'abc' }, { postalcode:'qwerty1', cT: 43, latitude:57.223524, longitude: -1.435453, call_reason: 'xyz1', Call_Sub_reason:'abc1' }];

var formatted = items.map(x => {
  var xy = Object.assign({}, x);
  
  xy.location = [xy.latitude, xy.longitude]
  delete xy.latitude;
  delete xy.longitude;
  
  return xy;
})

console.log(formatted);

edited Oct 11, 2018 at 9:06

answered Oct 11, 2018 at 8:44

Adrian

8,6573 gold badges28 silver badges47 bronze badges

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

3 Comments

BritishWerewolf Over a year ago

Well, you beat me by 3 minutes so have in upvote in lieu of me deleting my identical answer. I was too busy getting distracted lol

Daniel Frech Over a year ago

Be arware, that "items.map" will change the "items" array as well and not only the new "formattedItems" array.

Adrian Over a year ago

@DanielFrech Good spot. Corrected.

ciphrd · Accepted Answer · 2018-10-11 08:36:20Z

0

What do you mean by "iterate through variable of variable in array" ?

Both of the data you wrote are the same, if you meant that you would like to loop through the items in the array, you can do so like this:

es5

for (var i = 0; i < data1.length; i++) {
  var dataItem = data1[i];
  /**
   * dataItem will be
   * { postalcode:'qwerty', cT: 23, location:[57.232324,-2.343543], call_reason: 'xyz', Call_Sub_reason:'abc' },
   */
}

es6

for (let dataItem of data1) {
  // same
}

answered Oct 11, 2018 at 8:36

ciphrd

917 bronze badges

1 Comment

BritishWerewolf Over a year ago

They're not the same... A new key is added called location which combines latitude and longitude.

barbsan · Accepted Answer · 2018-10-11 08:49:05Z

0

You can use Array#map method and object destructuring

var arr = [{
        postalcode:'qwerty',
        cT: 23,
        latitude:57.232324,
        longitude: -2.343543,
        call_reason: 'xyz',
        Call_Sub_reason:'abc'
    },
    {
        postalcode:'qwerty1',
        cT: 43,
        latitude:57.223524,
        longitude: -1.435453,
        call_reason: 'xyz1',
        Call_Sub_reason:'abc1'
    }];
    
   var result =  arr.map(
   ({postalcode, cT, latitude, longitude, call_reason, Call_Sub_reason}) => ({postalcode, location: [ latitude, longitude], cT, call_reason, Call_Sub_reason})
   );
   console.log(result)

answered Oct 11, 2018 at 8:49

barbsan

3,46811 gold badges23 silver badges29 bronze badges

Comments

brk · Accepted Answer · 2018-10-11 08:54:46Z

0

Use array map which will create a new array and return the object

var data1 = [{
    postalcode: 'qwerty',
    cT: 23,
    latitude: 57.232324,
    longitude: -2.343543,
    call_reason: 'xyz',
    Call_Sub_reason: 'abc'
  },
  {
    postalcode: 'qwerty1',
    cT: 43,
    latitude: 57.223524,
    longitude: -1.435453,
    call_reason: 'xyz1',
    Call_Sub_reason: 'abc1'

  }
];


let newArray = data1.map((item) => {
  return {
    postalcode: item.postalcode,
    cT: item.cT,
    location: item.location,
    call_reason: item.call_reason,
    Call_Sub_reason: item.Call_Sub_reason
  }
})
console.log(newArray)

answered Oct 11, 2018 at 8:54

brk

50.3k10 gold badges59 silver badges85 bronze badges

Comments

Daniel Frech · Accepted Answer · 2018-10-11 09:24:18Z

0

Building on the answer of @Adriani6, the following does the same but leaves the data1 array unchanged if that is needed to avoid possible side effects:

const items = [{ postalcode:'qwerty', cT: 23, latitude:57.232324, longitude: -2.343543, call_reason: 'xyz', Call_Sub_reason:'abc' }, { postalcode:'qwerty1', cT: 43, latitude:57.223524, longitude: -1.435453, call_reason: 'xyz1', Call_Sub_reason:'abc1' }];

let formattedItems = items.map(item => {
  let newItem = {...item};
  newItem.location = [newItem.latitude, newItem.longitude];
  delete newItem.latitude;
  delete newItem.longitude;
  return newItem;
});

console.log(items);
console.log(formattedItems);

edited Oct 11, 2018 at 9:24

answered Oct 11, 2018 at 9:09

Daniel Frech

3352 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to iterate through variable of variable provided in array in jquery?

5 Answers 5

3 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related