Extract certain Columns and Rows from a json string

Question

I get a JSON response like this from a server,

{ id : 1, text : 'Name City Country \nJohn \n Chicago \nIllinois \nAlbert \nHouston \nTexas ' }

if I do console.log(response.text); the output is like this in tabular form

Now I want only want the Name column along with the rows and the output should look like this

Suggest me a workaround for this. Since the value is a string I'm facing a lot of trouble to extract only the required columns

score 1 · Accepted Answer · answered Aug 27 '18 at 13:12

1

I haven't tested this, but something like this should work:

var jsonData = "{ id : 1, text : 'Name City Country \nJohn \n Chicago \nIllinois \nAlbert \nHouston \nTexas ' }";

var obj1 = jsonData.split('\n');

for(var i= 1; i<obj1.length-2; i=i+3) 
{
  console.log("Name: " +obj1[i]+", City: "+obj1[i + 1]+", Country: " +obj1[i + 2]);

}

answered Aug 27 '18 at 13:12

Praneet Nadkar

823
7
16

can you explain me why we used i=1 instead of i=0 and obj1.length-2 instead of obj1.length ? – node_man Dec 20 '18 at 05:34

score 0 · Answer 2 · answered Aug 27 '18 at 13:01

0

Use trim and split to get the Name City and Country texts.

const obj = { id : 1, text : 'Name City Country \nJohn \n Chicago \nIllinois \nAlbert \nHouston \nTexas ' }

console.log(obj.text.split("\n")[0].trim().split(" "));

answered Aug 27 '18 at 13:01

kemicofa ghost

16,349
8
82
131

score 0 · Answer 3 · answered Aug 27 '18 at 13:02

0

You can use any of the javascript csv parser to parse the text to csv and access the particular column.

Ref: javascript-code-to-parse-csv-data

answered Aug 27 '18 at 13:02

Elanchezhian Narayanasamy

1,214
1
17
31

Extract certain Columns and Rows from a json string

3 Answers3