Is there a way to efficiently parse and categorize erroneous JSON data in JavaScript?

Question

Is there a way to efficiently parse and categorize erroneous JSON data in JavaScript?

Resolved my issue

var allKeys = ["key","en","ar"];
for(var i=0;i<allKeys.length;i++) {
  for(j=0;j<jsonText.Sheet1.length;j++) { 
   console.log(allKeys[i] + ' - ' + jsonText.Sheet1[j][allKeys[i]]);
  }
}

Live demonstration

Appreciation to @Aniket Sinha

How can I parse and organize incorrect JSON data?

The invalid JSON data provided;

{
  "Sheet1": [
    {
      "key": "title",
      "en": "title",
      "ar": "arabic_title", //comma at the end here
    },
    {
      "key": "content",
      "en": "content",
      "ar": "arabic_content",  //comma at the end here
    }
  ]
}

Desired output:

key - title

key - content

en - title

en - content

ar - arabic_title

ar - arabic_content

javascript json

Answer 1

Answer №1

Understanding JSON.parse() Method

var data = JSON.parse('{"Sheet1":[{"key":"title","en":"title","ar":"arabic_title"},{"key":"content","en":"content","ar":"arabic_content"}]}');
var key = data.Sheet1[0].key;
key === "title";

UPDATE:

The JSON string provided contains errors in formatting. There should be no comma after "ar": "arabic_title" and "ar": "arabic_content".

Answer 2

Understanding JSON.parse() Method

var data = JSON.parse('{"Sheet1":[{"key":"title","en":"title","ar":"arabic_title"},{"key":"content","en":"content","ar":"arabic_content"}]}');
var key = data.Sheet1[0].key;
key === "title";

UPDATE:

The JSON string provided contains errors in formatting. There should be no comma after "ar": "arabic_title" and "ar": "arabic_content".

Is there a way to efficiently parse and categorize erroneous JSON data in JavaScript?

Resolved my issue

Answer №1

Similar questions

Retrieve JSON and HTML in an AJAX request

if statement not recognizing data returned from PHP function

Receiving a Javascript Callback from Paypal

What is the best approach for organizing JavaScript/CoffeeScript in a Rails 5 project for optimal efficiency?

How to Efficiently Organize OpenAI AI Responses Using TypeScript/JavaScript and CSS

Looping through NavItems component using JavaScript or Angular

Encountering an issue when running the command "ng new my-app" after updating the @angular/cli package

Storing the order of jQuery UI Sortable in the WordPress Admin Panel

What is the best way to position a tooltip near an element for optimal visibility?

Using JavaScript for Text Processing on Disk

"Every time an Ajax call is successful, the 'else' clause in

The Vanilla JS script in Next.js fails to execute upon deployment

What is the proper way to delete a callback from a promise object created by $q.defer() in AngularJS?

AngularJS dropdown not reflecting changes when using ng-selected

Selecting the "pretty print" format for your Graph API request specifically

Tips for preventing the use of website URLs as variables in jQuery ajax() calls:

How come I am getting the desired section from my split string only after running the function twice?

Address NPM vulnerabilities through manual fixes

Testing a component in Angular 2 that utilizes the router-outlet functionality

Using JavaScript to Redirect to Homepage upon successful Ajax response on local server