I have a .txt file which has tab (\t) and semicolon (;) separated data, and I want to read the data and create JSON object. I tried the regular expression but I am not able to create a proper regular expression. Any help would be appreciated.

test.txt

sam tory 22;raj kumar 24

output.json

[
    {
        "Fname": "sam",
        "lastname": "troy",
        "Age": "22",
    },
    {
        "Fname": "raj",
        "lastname": "kumar",
        "Age": "24",
    }
]

I have a .txt file which has tab (\t) and semicolon (;) separated data, and I want to read the data and create JSON object. I tried the regular expression but I am not able to create a proper regular expression. Any help would be appreciated.

test.txt

sam tory 22;raj kumar 24

output.json

[
    {
        "Fname": "sam",
        "lastname": "troy",
        "Age": "22",
    },
    {
        "Fname": "raj",
        "lastname": "kumar",
        "Age": "24",
    }
]

• javascript
• node.js
• regex

• 1 Use fs to read the file, then split by ; and parse your data. – Striped Commented Feb 7, 2018 at 14:13
• but what about tab separated data ? – abhi Commented Feb 7, 2018 at 14:14
• Split by \t, I just test and it works. – Striped Commented Feb 7, 2018 at 14:14

3 Answers 3

Use the fs module to read the contents of the file.

var content = fs.readFileSync("profiles.tsv", "utf8");

Then map through the individual entries to transform them into an object:

const file = 'sam     tory  22;raj  kumar   24';
const json = file.split(';')
    .map(profile => {
        const [Fname, lastname, Age] = profile.split('\t');
        return { Fname, lastname, Age };
    });

console.log(json)

You should use the JavaScript split function to split your text.

var r = [];
var t = "sam	tory	22;raj	kumar	24";
var v = t.split(";");
for (var i = 0; i < v.length; i++) {
  var w = v[i].split("\t");
  r.push({
    Fname: w[0],
    lastname: w[1],
    Age: w[2]
  });
}
console.log(r);

Use the library csvtojson: https://www.npmjs./package/csvtojson

Here is testing code:

const csv=require('csvtojson')

const filePath='test.tsv'

var main = async () => {
  const jsonArray = await csv({delimiter:'\t'}).fromFile(filePath);
  console.log("jsonArray:", jsonArray);
}

main()