String to JSON array using Node

This question is similar to string-to-json-array-of-json-objects. I have the following string:

"['Phonetype':'Pre','Phone':'918282311','Phonetype':'pre','Phone':'918333222']"


How to convert this string to an array of objects using node?

Am reading data from a CSV file using csvtojson. Excel sheet contains a field phoneNumber. This field contains the above mentioned data. Am getting this data as string from the csv file. I want the data as JSON.

I tried JSON.parse(string). But I got the following error:

JSON.parse(string)

Unhandled rejection SyntaxError: Unexpected end of JSON input
at JSON.parse (<anonymous>)


Code:

csv().fromFile(csvFilePath)
.then((jsonObj)=>
var a = jsonObj[0].phoneNumber;
console.log(a);
console.log(JSON.parse(a));
);


Here console.log(a) prints ['Phonetype':'Pre','Phone':'918282311','Phonetype':'pre','Phone':'918333222'] as a string. When I try to convert into array of objects in the next line, it throws exception.

console.log(a)

['Phonetype':'Pre','Phone':'918282311','Phonetype':'pre','Phone':'918333222']

string

2 Answers
2

If it contains 'single quotes' instead of "double quotes" then it is not valid JSON.

You will need to do a .replace(/'/g, '"')

console.log(JSON.parse("['Phonetype':'Pre','Phone':'918282311','Phonetype':'pre','Phone':'918333222']".replace(/'/g, '"')));

JSON.parse works fine on that string.

console.log(JSON.parse('["Phonetype":"Pre","Phone":"918282311","Phonetype":"pre","Phone":"918333222"]'));

Your data is already an object and doesn't need parsing, try

csv().fromFile(csvFilePath)
.then((jsonObj)=>
var a = jsonObj[0].phoneNumber;
console.log(a);
console.log(a[0].Phonetype);
console.log(a[0].Phone);
console.log(a[1].Phonetype);
console.log(a[1].Phone);
);


Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy