Converting an array of strings into a JSON object using JavaScript

Question

Converting an array of strings into a JSON object using JavaScript

Below is an array that needs to be transformed into a JSON object:

data = [
    "Id = 2",
    "time = 10:59",
    "Topic = xxxxxxxxxxxxxxxx",
    "GUEST3",
    "Role = GS",
    "Infos = Connecticut",
    "GUEST4",
    "Role = HS",
    "Infos = Delaware",
    "GUEST5",
    "Role = CS",
    "Infos = Hawaii"
]

I am looking to convert it into the following JSON object structure:

data = [   
 {    
    Id : 2,  
    time : '10:59',
    Topic : 'xxxxxxxxxxxxxxxx', 
    GUEST3:
           {
             Role : 'GS',
             Infos : 'Connecticut',
           }
   GUEST4:
           {
            Role : 'HS',
            Infos : 'Delaware',  
   GUEST5:
           {
            Role : 'CS',
            Infos : 'Hawaii'
           }
 }

javascript arrays json

Answer 1

Answer №1

Find below a code snippet to achieve the desired outcome.

The explanation is provided within the code comments, but essentially it iterates through each string in the array and determines whether it's a key-value pair or another layer of the object.

const data = ["Id = 2", "time = 10:59", "Topic = xxxxxxxxxxxxxxxx", "GUEST3", "Role = GS", "Infos = Connecticut", "GUEST4", "Role = HS", "Infos = Delaware", "GUEST5", "Role = CS", "Infos = Hawaii"];

// Initializing new object
let obj = {};
// Keeping track of current object level
let level;

// Iterating through the array
for (let item of data) {
    if (item.includes('=')) {
        let split = item.split('=');
        let key = split[0].trim();
        let cont = split[1].trim();
        
        if (level) {
            obj[level][key] = cont
        } else {
            obj[key] = cont
        }
    } else {
        level = item;
        obj[item] = {};
    }
}

console.log(obj)

If you have any trouble understanding the code, feel free to ask for clarification.

EDIT:

An updated solution combining elements from previous answers.

const data = ["Id = 2", "time = 10:59", "Topic = xxxxxxxxxxxxxxxx", "GUEST3", "Role = GS", "Infos = Connecticut", "GUEST4", "Role = HS", "Infos = Delaware", "GUEST5", "Role = CS", "Infos = Hawaii"]

let topLevelObj = currentObj = {};
data.map(a => a.split(' = ')).forEach(e => {e.length > 1 ? currentObj[e[0]] = e[1] : currentObj = topLevelObj[e] = {}});
console.log(topLevelObj);

Answer 2

Find below a code snippet to achieve the desired outcome.

The explanation is provided within the code comments, but essentially it iterates through each string in the array and determines whether it's a key-value pair or another layer of the object.

const data = ["Id = 2", "time = 10:59", "Topic = xxxxxxxxxxxxxxxx", "GUEST3", "Role = GS", "Infos = Connecticut", "GUEST4", "Role = HS", "Infos = Delaware", "GUEST5", "Role = CS", "Infos = Hawaii"];

// Initializing new object
let obj = {};
// Keeping track of current object level
let level;

// Iterating through the array
for (let item of data) {
    if (item.includes('=')) {
        let split = item.split('=');
        let key = split[0].trim();
        let cont = split[1].trim();
        
        if (level) {
            obj[level][key] = cont
        } else {
            obj[key] = cont
        }
    } else {
        level = item;
        obj[item] = {};
    }
}

console.log(obj)

If you have any trouble understanding the code, feel free to ask for clarification.

EDIT:

An updated solution combining elements from previous answers.

const data = ["Id = 2", "time = 10:59", "Topic = xxxxxxxxxxxxxxxx", "GUEST3", "Role = GS", "Infos = Connecticut", "GUEST4", "Role = HS", "Infos = Delaware", "GUEST5", "Role = CS", "Infos = Hawaii"]

let topLevelObj = currentObj = {};
data.map(a => a.split(' = ')).forEach(e => {e.length > 1 ? currentObj[e[0]] = e[1] : currentObj = topLevelObj[e] = {}});
console.log(topLevelObj);

Answer 3

Answer №2

It appears that your input array is structured in a non-standard way. If this is indeed the format you receive your data in, you can utilize the provided code snippet to process it accordingly. However, I would strongly advise double-checking and exploring options to modify the backend system (or the source of this data) to provide a standard JSON string or JavaScript object for better compatibility.

var data = [
  "Id = 2",
  "time = 10:59",
  "Topic = xxxxxxxxxxxxxxxx",
  "GUEST3",
  "Role = GS",
  "Infos = Connecticut",
  "GUEST4",
  "Role = HS",
  "Infos = Delaware",
  "GUEST5",
  "Role = CS",
  "Infos = Hawaii"
];

var result = {};
var putInto = result;
for (let token of data) {
  if (token.indexOf('=') != -1) {
    let nameValue = token.split('=');
    let name = nameValue[0].trim();
    let value = nameValue[1].trim();
    putInto[name] = value;
  } else {
    let child = {};
    result[token] = child;
    putInto = child;
  }
}

console.log(result)

Answer 4

It appears that your input array is structured in a non-standard way. If this is indeed the format you receive your data in, you can utilize the provided code snippet to process it accordingly. However, I would strongly advise double-checking and exploring options to modify the backend system (or the source of this data) to provide a standard JSON string or JavaScript object for better compatibility.

var data = [
  "Id = 2",
  "time = 10:59",
  "Topic = xxxxxxxxxxxxxxxx",
  "GUEST3",
  "Role = GS",
  "Infos = Connecticut",
  "GUEST4",
  "Role = HS",
  "Infos = Delaware",
  "GUEST5",
  "Role = CS",
  "Infos = Hawaii"
];

var result = {};
var putInto = result;
for (let token of data) {
  if (token.indexOf('=') != -1) {
    let nameValue = token.split('=');
    let name = nameValue[0].trim();
    let value = nameValue[1].trim();
    putInto[name] = value;
  } else {
    let child = {};
    result[token] = child;
    putInto = child;
  }
}

console.log(result)

Answer 5

Answer №3

To start off, ensure that the data is correctly formatted. One method is to structure it as an array of arrays.

const stringData = ["Id = 2","time = 10:59","Topic = xxxxxxxxxxxxxxxx","GUEST3","Role = GS" ,"Infos = Connecticut","GUEST4","Role = HS","Infos = Delaware","GUEST5","Role = CS","Infos = Hawaii"]

const formattedData = stringData.map(entry => entry.split('='))

Next, you can utilize something similar to _.fromPairs from lodash

const json = _.fromPairs(formattedData);

This will give you a plain JSON output. While it may not be exactly what you require, it's a good starting point.

Answer 6

To start off, ensure that the data is correctly formatted. One method is to structure it as an array of arrays.

const stringData = ["Id = 2","time = 10:59","Topic = xxxxxxxxxxxxxxxx","GUEST3","Role = GS" ,"Infos = Connecticut","GUEST4","Role = HS","Infos = Delaware","GUEST5","Role = CS","Infos = Hawaii"]

const formattedData = stringData.map(entry => entry.split('='))

Next, you can utilize something similar to _.fromPairs from lodash

const json = _.fromPairs(formattedData);

This will give you a plain JSON output. While it may not be exactly what you require, it's a good starting point.

Converting an array of strings into a JSON object using JavaScript

Answer №1

Answer №2

Answer №3

Similar questions

Retrieving information from CRM online utilizing the Web API

"The Django querydict receives extra empty brackets '[]' when using jQuery ajax post to append items to a list in the app

Utilizing Vue3's draggable component to seamlessly incorporate items

Looking for assistance with reviewing and optimizing Angular UI-Router implementation

How can I prevent opening duplicate tabs of the same website simultaneously?

The value produced by the interval in Angular is not being displayed in the browser using double curly braces

Is there a way to incorporate bubbles onto all of my y-axis values, as well as implement a mouseover feature for each one?

Efficient way to handle nested variables in templates with Nunjucks or alternative approaches

JavaScript function to double the odd numbers

I would love to hear your suggestions for a custom select element plugin in jQuery

Strategies for iterating through file inputs and organizing them into arrays

Showcasing two sets of data from an array using chart.js within a node.js environment

The issue of appending request URLs in the $.ajax function

Display only the selected index and conceal the rest

Hide the button when you're not actively moving the mouse, and show it when you start moving it

What causes the inconsistency in TypeScript's structure typing?

Displaying threaded discussions in React

Bringing a JavaScript function into a TypeScript file results in it being treated as a namespace

obtain data from an array using Angular 5

What is the best way to merge multiple chunks of arrays into a single array