MATLAB jsonLab to PARSE a JSON object

Question

I have a json object and I am trying to parse to object in MATLAB to into a cell array however when I parse the filename it throughs this error...

`Error using loadjson>error_pos (line 431) JSONparser:invalidFormat: String starting with " expected at position 18767: nt": "neutral",} {"created_at": "Mon

Error in loadjson>parseStr (line 301) error_pos('String starting with " expected at position %d');

Error in loadjson>parse_object (line 169) str = parseStr(varargin{:});

Error in loadjson (line 66) data{jsoncount} = parse_object(opt);`

Some sample data in the JSON object is:

{"created_at": "Mon Oct 27 20:35:47 +0000 2014", "tweet": "Silver Finished Up, Gold, Copper, Crude Oil, Nat Gas Down - Live Trading News http://t.co/jNLTUIgHwA", "id": 526834668759285761, "sentiment": "negative"}
{"created_at": "Mon Oct 27 20:36:21 +0000 2014", "tweet": "Gold, Silver slips on lacklustre demand- The Economic Times http://t.co/Jd5Tn9ctfX", "id": 526834810300289024, "sentiment": "negative"}
{"created_at": "Mon Oct 27 20:36:26 +0000 2014", "tweet": "Price of Gold is $1225.7 on 10-27-2014 16:36:13. - http://t.co/yYP5ubMFEA", "id": 526834831209291777, "sentiment": "positive"}
{"created_at": "Mon Oct 27 20:36:30 +0000 2014", "tweet": "Diwali Spurs Uptick In Physical Gold Demand - Barclays - http://t.co/nxIteCvusL", "id": 526834849563172864, "sentiment": "positive"}
{"created_at": "Mon Oct 27 20:37:50 +0000 2014", "tweet": "Price of Gold is $1225.8 on 10-27-2014 16:37:12. - http://t.co/yYP5ubMFEA", "id": 526835183639883776, "sentiment": "positive"}
{"created_at": "Mon Oct 27 20:38:03 +0000 2014", "tweet": "#Platinum/#Gold #ratio #trading 1.026, so 1 oz of #Platinum is $32 more than 1 oz of #Gold - https://t.co/EkERU2sQus", "id": 526835236269998080, "sentiment": "positive"}

Can anyone pass on their thoughts on the matter ?

The json is not valid, try a validator: jsonlint.com

Daniel
– Daniel

2014-12-21 11:08:02 +00:00
Commented Dec 21, 2014 at 11:08 — Daniel
– Daniel, Commented Dec 21, 2014 at 11:08

rayryeng · Accepted Answer · 2014-12-21 19:41:54Z

1

You didn't provide us the entire picture. The JSON structure before the {"created_at":... seems to be missing a double quotation mark. There also seems to be an unnecessary comma at the end. This should probably go outside of the curly braces. This also makes sense because I'm assuming that we haven't reached the end of your JSON file yet, and you need to use commas to separate between the different fields.

As such, locate the following line:

...nt": "neutral",}

Change it to this:

..."nt": "neutral"},

FWIW, the error message is quite clear. It was expecting a " literal, but it is missing. Also, Daniel provided a great tool in his comment to you called JSONLint. Use the URL to validate whether or not your JSON structure is valid.

edited Dec 21, 2014 at 19:41

answered Dec 21, 2014 at 19:30

rayryeng

105k22 gold badges201 silver badges206 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MATLAB jsonLab to PARSE a JSON object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related