title: How to remove the element in dimensional array in javascript
body: <pre><code>{"success":true,
  "alldata": [
      {"name":"a","location":"market","age":12,"hobby":"singing","point":99.83},
      {"name":"b","location":"home","age":23,"hobby":"football","point":99.98},
      {"name":"c","location":"drugstore","age":17,"hobby":"game","point":99.99},
      ........ ,
      {"name":"z","location":"school","age":15,"hobby":"piano","point":100}
      ]
  }
  </code></pre>
  
  <p>The data above is on a website</p>
  
  <p>I want it to parse at google spreadsheet</p>
  
  <pre><code>var url = "website address"
  
  function getdata() { 
      var sheet = SpreadsheetApp.getActiveSheet(); 
      sheet.getRange('A1').setValue('fetching...'); 
  
      try { 
      var response = UrlFetchApp.fetch(url); 
      var json = JSON.parse(response.getContentText()); 
      var data = {}; 
  
          if (json &amp;&amp; json.alldata) { 
              json.alldata.forEach(function(elem) { 
              data[elem.name] = elem}); 
              } 
  
  
          sheet.getRange('A1').setValue('success'); 
          sheet.getRange('B1').setValue(JSON.stringify(data)); 
          }
          catch(ex) {sheet.getRange('A1').setValue('error');} 
          } 
  </code></pre>
  
  <p>I succeeded until this</p>
  
  <p>But the 'alldata' on the website is getting too large</p>
  
  <p>and I got an error message on sheet</p>
  
  <pre><code>"You entered more than 50,000 characters in a single cell."
  </code></pre>
  
  <p>So, I want to erase 'location' and 'point'</p>
  
  <p>But I don't know how can I do that</p>
  
  <pre><code>delete json.alldata["location"]
  </code></pre>
  
  <p>I tried it but didn't work</p>
  
  <pre><code>for(var i = 0; i&lt;json.alldata.length;i++){
      if(json.alldata[i][1] == "location"){
      json.alldata[i].splice(1.1);
      }
  {
  </code></pre>
  
  <p>I also tried but didn't work</p>
  
  <p>How can I do this? please help..
  Thanks</p>