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

Jumping Iframe Anchor Link in Src

What is the reason for the retrieval of jquery-3.5.1.min.js through the request.params.id expression?

Dynamic tag names can be utilized with ref in TypeScript

Do I have to divide the small functions in my Node.js controller into smaller ones?

Steps for dynamically loading the correct pane without having to refresh the header, footer, or left navigation

retrieve the checkbox formgroup using the Response API

Set the parameter as optional when the type is null or undefined

worldpay implements the useTemplateForm callback function

Issue with the recursive function in javascript for object modification

The issue with ngx-bootstrap-modal is that it fails to interpret HTML elements

CodeIgniter encountering a dilemma with session logout functionality

Having trouble converting data back to JSON format after using JSON.parse in an ejs file with node and express

Managing conflicting versions of React in a component library created with Webpack and Storybook

JS | How can we make an element with style=visibility:hidden become visible?

Utilize Reactjs to efficiently showcase a collection of arrays within an object

Why does Chrome keep retrieving an outdated JavaScript file?

Issue with Material UI Table not refreshing correctly after new data is added

Updating a div using PHP elements

I keep encountering a 404 error page not found whenever I try to use the useRouter function. What could

Navigating the interface types between Angular, Firebase, and Typescript can be tricky, especially when working with the `firebase.firestore.FieldValue`