Converting text data into JSON format using JavaScript

Question

Converting text data into JSON format using JavaScript

When working with my application, I am loading text data from a text file:

The contents of this txt file are as follows:

console.log(myData):

### Comment 1
## Comment two
dataone=1
datatwo=2
## Comment N
dataThree=3

I am looking to convert this data to JSON by following these steps:

Remove all comment lines (beginning with #) and empty lines
Replace all = with :
Add quotes to the data attributes to make it look like this
Wrap everything inside { }

The resulting JSON would appear as follows:

{
"dataone":"1"
"datatwo":"2"
"dataThree":"3"
}

Is there a quick way to achieve this formatting?

javascript angular typescript ecmascript-6

Answer 1

Answer №1

If you're looking for a basic and straightforward solution, how about trying this approach:

const data = myData
  .split('\n')
  .filter(line => !line.startsWith('#') && line.includes('='))
  .map(line => line.split('='))
  .reduce((obj, [key, value]) => {
     obj[key] = value.trim();
     return obj;
  }, {});

const jsonData = JSON.stringify(data);

Limitations

There is no support for duplicate keys, although standard JSON libraries also do not allow them.
All values will be treated as strings, even numerical values may remain in string format.
Error handling has not been implemented for scenarios not covered in the original example text.

Answer 2

If you're looking for a basic and straightforward solution, how about trying this approach:

const data = myData
  .split('\n')
  .filter(line => !line.startsWith('#') && line.includes('='))
  .map(line => line.split('='))
  .reduce((obj, [key, value]) => {
     obj[key] = value.trim();
     return obj;
  }, {});

const jsonData = JSON.stringify(data);

Limitations

There is no support for duplicate keys, although standard JSON libraries also do not allow them.
All values will be treated as strings, even numerical values may remain in string format.
Error handling has not been implemented for scenarios not covered in the original example text.

Converting text data into JSON format using JavaScript

Answer №1

Limitations

Similar questions

Stopping errors are a common occurrence in synchronous AJAX

Angular allows for dynamic sourcing of iframes

Changing the button class during an event in Angular 4

To toggle between two scope variables within a view when one is not defined

Invoke a function within one component using another component

Exploring the functionality of the onblur HTML attribute in conjunction with JavaScript's ability to trigger a

Retrieve information from a changing HTML table

The jQuery change function appears to be functioning properly, but it is not producing any results

Making sure the axios API call is completed before rendering the child component with props

Lazy loading images in a grid using React's react-lazy-load component

Bootstrap3 Remote Modal experiencing conflict due to Javascript

The ng-repeat functionality in Angular 2 is not functioning correctly when trying to select an option from an array of objects. Instead of displaying the actual object, it is

Assign the value/text of a div element by using JavaScript/jQuery within a PHP loop

Is it possible to receive returned string values using fetch()?

Sending data from a Node.js backend to a React.js frontend using res.send

"Dealing with conflicts between RMQ and TypeORM in a NestJS

Trigger a jQuery event when a particular element has finished loading

Unable to reinitialize the DataTable using Angular Datatable

After being deployed on Vercel, React is mistakenly redirecting to the incorrect file, although it functions properly when

Implementing onClick functionality in RecyclerView post JSON data extraction