Converting Plain Text into Json Using Javascript

Question

Converting Plain Text into Json Using Javascript

I am struggling to convert a lengthy list into a JSON or JavaScript object using JavaScript. Despite searching online, I have not been able to find a suitable solution.

Afghanistan- 132
South Africa - 7560
Albania - 175
Germany - 230
Andorra - 370

This is just a snippet of the complete list, which is too long to manually convert.

The desired output after conversion should resemble this:

[
    {
       "id": 132,
       "country_name":"Afghanistan"
    },
    {
       "id": 7560,
       "country_name":"South Africa"
    },
    {
       "id": 175,
       "country_name":"Albania"
    },
    {
       "id": 230,
       "country_name":"Germany"
    },
    {
       "id": 370,
       "country_name":"Andorra"
    }
 ]

javascript json

Answer 1

Answer №1

Begin by breaking down the plaintext list using the newline character, resulting in an array of strings such as ["Afghanistan- 132", "South Africa - 7560", ...].

Subsequently, iterate through this list and separate each string to extract the content before and after the dash.

Creating an object within each iteration will produce an array of objects, with any extra whitespace removed from the split values.

To convert this into a usable JSON string, simply employ JSON.stringify() on the transformed data.

const stringList = `Afghanistan- 132
South Africa - 7560
Albania - 175
Germany - 230
Andorra - 370`

const mappedList = stringList.split("\n").map(item => {
    const splitItem = item.split('-');
    return {id: splitItem[1].trim(), country_name: splitItem[0].trim()}
});

const jsonString = JSON.stringify(mappedList);

console.log(jsonString);

Answer 2

Begin by breaking down the plaintext list using the newline character, resulting in an array of strings such as ["Afghanistan- 132", "South Africa - 7560", ...].

Subsequently, iterate through this list and separate each string to extract the content before and after the dash.

Creating an object within each iteration will produce an array of objects, with any extra whitespace removed from the split values.

To convert this into a usable JSON string, simply employ JSON.stringify() on the transformed data.

const stringList = `Afghanistan- 132
South Africa - 7560
Albania - 175
Germany - 230
Andorra - 370`

const mappedList = stringList.split("\n").map(item => {
    const splitItem = item.split('-');
    return {id: splitItem[1].trim(), country_name: splitItem[0].trim()}
});

const jsonString = JSON.stringify(mappedList);

console.log(jsonString);

Converting Plain Text into Json Using Javascript

Answer №1

Similar questions

Even in report-only mode, Content Security Policy effectively blocks the execution of inline scripts

Signs that indicate you have reached the bottom of the page

JavaScript doesn't pause for the data to come back, resulting in an undefined value

Differences in accessing the previous state between React's useCallback and useState's setState(prevState)

What is the process for loading a font file in Vue.js and webpack?

Is it possible to leverage specific client-side Javascript APIs on the server-side?

Using Angular JS for Traditional Multi-page Websites

Enhancing functionality in Javascript by employing prototype descriptor for adding methods

Converting Dynamo DB stream data into Json format

Using PHP to retrieve JSON data

The raycaster in Three.js seems to be having trouble selecting the correct object

jquery persistently selects element even after altering the class

JQuery was partially activated

What is the best way to retrieve the value from a PHP request?

Dynamically loading components within an Angular application

Could there be any issues with the structure of my mongoose schema?

Angular facing problems with tracking comment counts in Disqus

The alert feature seems to be malfunctioning. I attempted to use an external script file with the code "alert('hello world');" but it did not produce the desired alert

Can you explain how I can declare a variable to store a scraped element in Puppeteer?

Ways to retrieve all elements based on their class names?