How to convert from text to JSON using NodeJS?

Question

I want to convert a text file to JSON, but in a very particular way. My text file looks like this:

Data 1:
datapoint1-1 = 21
datapoint1-2 = 23
Data 2:
datapoint2-1 = 21
datapoint2-2 = 23
datapoint2-3 = 23

I want to create a JSON file that separates this data like this:

{
 {
 "Data": "1",
 "Datapoints": [
   {
    "datapoint1-1": "21",
    "datapoint1-2": "23"
   }
  ]
 },
 {
 "Data": "2",
 "Datapoints": [
  {
   "datapoint2-1": "21",
   "datapoint2-2": "23",
   "datapoint2-3": "23"
  }
 ]
 }
}

My first step has split the data into 2 arrays inside an array. The first array is Data 1 plus its data-points and the second is Data 2 plus its data-points.

Now I am stuck on how I can convert those arrays into the JSON format I want. Does anyone have an idea? or can direct me in the right direction for this?

Thanks,

I haven't found anything helpful. Only thing I've tried is a simple JSON.stringify(obj) but it isn't specific enough to what I want as an outcome. — Mauricio
– Mauricio, Commented Dec 31, 2018 at 3:46
JSON.stringify tend to convert text format (those are like json format) to proper json format. — Pyae Phyoe Shein
– Pyae Phyoe Shein, Commented Dec 31, 2018 at 3:49
Your desired output isn't valid javascript or JSON. Is that supposed to be an array or an object? And why is Datapoints an array if it's always just going to have one item? — Mark
– Mark, Commented Dec 31, 2018 at 3:51
I made it into an array because I thought it'd be easier to use in my code, in case I want to reference a specific data point. — Mauricio
– Mauricio, Commented Dec 31, 2018 at 4:09

Yegor · Accepted Answer · 2018-12-31 04:30:00Z

Here is my solution

const input = `
  Data 1:
  datapoint1-1 = 21
  datapoint1-2 = 23
  Data 2:
  datapoint2-1 = 21
  datapoint2-2 = 23
  datapoint2-3 = 23
`

const array = input.split('\n').reverse()
const response = []
let template = {}
template['Datapoints'] = []
let switcher = false

array.map(arr => {
  // remove empty strings
  if (arr) {
    if (arr.includes('datapoint')) {
      const keyValue = arr.split(' = ')
      template.Datapoints.push({ [`${keyValue[0]}`]: keyValue[1] })
    } else {
      const keyValue = arr.split(' ')
      template.Datapoints.reverse()

      template[keyValue[0]] = keyValue[1].slice(0, -1)
      switcher = true
    }

    if (switcher) {
      response.push(template)
      template = {}
      template['Datapoints'] = []
      switcher = false
    }
  }
})

const finalResponse = response.reverse()

console.log(JSON.stringify(finalResponse, null, 2))

and in console you got

[
  {
    "Datapoints": [
      {
        "datapoint1-1": "21"
      },
      {
        "datapoint1-2": "23"
      }
    ],
    "Data": "1"
  },
  {
    "Datapoints": [
      {
        "datapoint2-1": "21"
      },
      {
        "datapoint2-2": "23"
      },
      {
        "datapoint2-3": "23"
      }
    ],
    "Data": "2"
  }
]

B.K tech_Info · Accepted Answer · 2022-03-15 04:18:36Z

0

To convert text files in JSON you can use the JACKSON OBJECT MAPPER jar in your code. Create a simple POJO. It will read JSON string from a file and map it to your class. Then you would need to convert the JSON string value to java object. This will help you with the same.

edited Mar 15, 2022 at 4:18

answered Jul 30, 2021 at 3:10

B.K tech_Info

154 bronze badges

1 Comment

Nick Mitchell Over a year ago

Hi there, the question specifically asks for NodeJs solution (not a java one).

Collectives™ on Stack Overflow

How to convert from text to JSON using NodeJS?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related