How to split String from json format in Node js

Question

I'm newbie at Node.js, here is my sample json format data. I want to split them into json format and need to get tid values. In node.js I tried to use JSON.parse(data) but it occured an error (becasue of [] symbols). is there a simple way to split them into json format and get the tid values?

[{"date":1535624757,"date_ms":1535624757427,"amount":90.389717,"price":0.00860497,"type":"buy","tid":251916659},{"date":1535624757,"date_ms":1535624757428,"amount":99.428689,"price":0.00860497,"type":"buy","tid":251916662},{"date":1535624757,"date_ms":1535624757469,"amount":384.65968,"price":0.00860497,"type":"buy","tid":251916663}]

JSON.parse works perfectly fine for me, using that data

CertainPerformance
– CertainPerformance

2018-08-31 02:06:57 +00:00
Commented Aug 31, 2018 at 2:06 — CertainPerformance
– CertainPerformance, Commented Aug 31, 2018 at 2:06

Mayur · Accepted Answer · 2022-07-11 13:23:00Z

JSON.parse takes a string variable,

[
    {
        "date": 1535624757,
        "date_ms": 1535624757427,
        "amount": 90.389717,
        "price": 0.00860497,
        "type": "buy",
        "tid": 251916659
    },
    {
        "date": 1535624757,
        "date_ms": 1535624757428,
        "amount": 99.428689,
        "price": 0.00860497,
        "type": "buy",
        "tid": 251916662
    },
    {
        "date": 1535624757,
        "date_ms": 1535624757469,
        "amount": 384.65968,
        "price": 0.00860497,
        "type": "buy",
        "tid": 251916663
    }
]

this code you goven is object variable.

you can use this

var data = JSON.parse('[{"date":1535624757,"date_ms":1535624757427,"amount":90.389717,"price":0.00860497,"type":"buy","tid":251916659},{"date":1535624757,"date_ms":1535624757428,"amount":99.428689,"price":0.00860497,"type":"buy","tid":251916662},{"date":1535624757,"date_ms":1535624757469,"amount":384.65968,"price":0.00860497,"type":"buy","tid":251916663}]')
console.log(data)

ctt · Accepted Answer · 2018-08-31 03:48:52Z

2

It appears as though you're trying to work with a Javascript object instead of a string that contains JSON encoded data. Consider working with the object directly. For example, you could use a for loop to iterate over the elements of data as follows:

const data =  [ {"date":1535624757,"date_ms":1535624757427,"amount":90.389717,"price":0.00860497,"type":"buy","tid":251916659},{"date":1535624757,"date_ms":1535624757428,"amount":99.428689,"price":0.00860497,"type":"buy","tid":251916662},{"date":1535624757,"date_ms":1535624757469,"amount":384.65968,"price":0.00860497,"type":"buy","tid":251916663}];

for (var i = 0; i < data.length; i++) {
  console.log(data[i].tid);
}

edited Aug 31, 2018 at 3:48

ctt

1,4459 silver badges19 bronze badges

answered Aug 31, 2018 at 3:22

Brian Hart

747 bronze badges

Comments

Andy Gaskell · Accepted Answer · 2018-08-31 02:55:14Z

Since the array you posted is not JSON within the context of a JavaScript program (though it is a valid standalone JSON document), let's say that data is the value of your array:

const data = [{
  "date":1535624757,
  "date_ms":1535624757427,
  "amount":90.389717,
  "price":0.00860497,
  "type":"buy",
  "tid":251916659
}, {
  "date":1535624757,
  "date_ms":1535624757428,
  "amount":99.428689,
  "price":0.00860497,
  "type":"buy",
  "tid":251916662
}, { 
  "date":1535624757,
  "date_ms":1535624757469,
  "amount":384.65968,
  "price":0.00860497,
  "type":"buy",
  "tid":251916663
}];

You can pull out the tids like this:

const tids = data.map(e => e.tid);

tids:

[ 251916659, 251916662, 251916663 ]

If you would like tids as a JSON string, you can use JSON.stringify:

const jsonTids = JSON.stringify(tids);

jsonTids:

'[251916659,251916662,251916663]'

Max Baldwin · Accepted Answer · 2018-08-31 02:39:57Z

-1

Because your JSON object is inside of an array (the [] symbol), you have to reference the JSON object by its index in the array. Like so.

const data = [{"date":1535624757,"date_ms":1535624757427,"amount":90.389717,"price":0.00860497,"type":"buy","tid":251916659},{"date":1535624757,"date_ms":1535624757428,"amount":99.428689,"price":0.00860497,"type":"buy","tid":251916662},{"date":1535624757,"date_ms":1535624757469,"amount":384.65968,"price":0.00860497,"type":"buy","tid":251916663}];

console.log(data[0]);

Here's some info on array's an their indexes.

edited Aug 31, 2018 at 2:39

answered Aug 31, 2018 at 2:10

Max Baldwin

3,4723 gold badges30 silver badges42 bronze badges

2 Comments

Jared Smith Over a year ago

Your code throws. Again, the problem is almost certainly that JSON.parse takes a string, you can't feed it a JavaScript data structure. Please run your code before posting it as an answer.

Max Baldwin Over a year ago

@JaredSmith right, you don't event have to parse it. Thanks

Collectives™ on Stack Overflow

How to split String from json format in Node js

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related