Translate simple text to json with node.js

Question

today i'd like to translate a text to json data

exemple :

1    kokoa#0368's Discord Profile Avatar    kokoa#0000    826
2    Azzky 陈东晓#7475's Discord Profile Avatar    Azzky 陈东晓#0000    703
3    StarKleey 帅哥#6163's Discord Profile Avatar    StarKleey 帅哥#0000    640

to =>

{
 "kokoa#0000": "826",
 "Azzky 陈东晓#0000": "703",
 "StarKleey 帅哥#0000": "640"
}

for the moment i have this one :

fs.appendFile(`./Text/mess.txt`, `${body.replace(/s Discord Profile Avatar/g, '').split(/[\n \t ' ']/)}`, function (err) {

So the result is this one =>

1,kokoa#0368,,kokoa#0000,826
2,Azzky 陈东晓#7475,,Azzky 陈东晓#0000,703
3,StarKleey 帅哥#6163,,StarKleey 帅哥#0000,640

But i would like delete firsts numbers, delete the duplicate array and make this one on .json

Someone know how can i do this ? And if i need new method to make this one, it's not a problem.

Thank you.

Michał Ziober · Accepted Answer · 2020-10-10T10:39:40.157

You can read file line by line and convert each line to a 2-elements array with key and value. For example, first line can be converted to:

['kokoa#0000','826']

As you can se 0 index is a key and 1 index is a value. When you convert all lines to this kind of array you can reduce it to an object and convert it to JSON.

See example method:

function convertLinesToJson(lines) {
    const dpaText = "Discord Profile Avatar";
    const jsonObject = lines
        //only with 'Discord ...' text
        .filter(line => line.includes(dpaText))
        //get what is after 'Discord ...' text and split into 2-elements array
        .map(line => {
            const index = line.indexOf(dpaText) + dpaText.length;
            const keyValue = line.substr(index).trim().split(/[ ]{4}/);
            return keyValue;
        })
        // convert [key, value] array into an object
        .reduce((accumulator, currentValue) => {
            accumulator[currentValue[0]] = currentValue[1];
            return accumulator;
        }, {});

    //convert object to JSON
    return JSON.stringify(jsonObject);
}

Usage:

let lines = [
    "1    kokoa#0368's Discord Profile Avatar    kokoa#0000    826",
    "2    Azzky 陈东晓#7475's Discord Profile Avatar    Azzky 陈东晓#0000    703",
    "3    StarKleey 帅哥#6163's Discord Profile Avatar    StarKleey 帅哥#0000    640"
];
const json = convertLinesToJson(lines);
console.log(json);

Above example code prints:

{"kokoa#0000":"826","Azzky 陈东晓#0000":"703","StarKleey 帅哥#0000":"640"}

Translate simple text to json with node.js

1 Answers1