Turning a string into a javascript object

Question

I'm calling in data from the Google Sheets API, and each row's content looks like this:

 {
   $t: "title: Test Title, gamelabel: Test Game, startdate: 2016-06-14"
 }

Is there any off-the-shelf / easy way to turn this string into a javascript object in this format?

{
 title : 'Test Title',
 gamelabel: 'Test Game',
 startdate: '2016-06-14
}

Note, the keys need to be dynamic (creating keys for whatever the sheets' heading is), so knowing exactly what keys will be in $t isn't possible.

Update: Using JSON.parse() doesn't work here, I suppose there's a hacky-ish way of doing this via:

 var temp = {};
 var params = $t.split(/:/g);
 for(var i = 0; i<params.length; i += 2){
  temp[params[i].trim()] = params[i + 1].trim(); 
 }

This doesn't actually work for the supplied format / is potentially a start but I dunno what's the best practice here.

@RobG: No; that isn't JSON.

SLaks
– SLaks

2016-05-31 02:41:27 +00:00
Commented May 31, 2016 at 2:41 — SLaks
– SLaks, Commented May 31, 2016 at 2:41
That looks like a job for eval()

Leo supports Monica Cellio
– Leo supports Monica Cellio

2016-05-31 02:41:46 +00:00
Commented May 31, 2016 at 2:41 — Leo supports Monica Cellio
– Leo supports Monica Cellio, Commented May 31, 2016 at 2:41
I edited in a semi-code sample into the question

JVG
– JVG

2016-05-31 02:49:30 +00:00
Commented May 31, 2016 at 2:49 — JVG
– JVG, Commented May 31, 2016 at 2:49
check here stackoverflow.com/questions/45015/…

Ari
– Ari

2016-05-31 02:52:08 +00:00
Commented May 31, 2016 at 2:52 — Ari
– Ari, Commented May 31, 2016 at 2:52
How are commata escaped in the field values?

Bergi
– Bergi

2016-05-31 02:54:18 +00:00
Commented May 31, 2016 at 2:54 — Bergi
– Bergi, Commented May 31, 2016 at 2:54

Bryan Chen · Accepted Answer · 2016-05-31 02:54:25Z

5

You can parse it easily with split assuming , and : will never appear in the key or value part.

$t.split(',')
    .map(s => s.split(':'))
    .reduce((o, s) => {
        o[s[0].trim()] = s[1].trim();
        return o;
    }, {});

answered May 31, 2016 at 2:54

Bryan Chen

46.7k19 gold badges119 silver badges148 bronze badges

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

Comments

boehm_s · Accepted Answer · 2016-05-31 02:53:41Z

1

The keys are dynamic but the structure has to remain the same :

{
xxx: "abc",
yyy: "bcd", ...
}

var str = "title: Test Title, gamelabel: Test Game, startdate: 2016-06-14";
var comaSplit = str.split(','), i, arr = [], obj = {};
for (i=0; i < comaSplit.length; i++)
  arr.push(comaSplit[i].split(':'));
for (i=0; i < arr.length; i++)
  obj[arr[i][0]] = arr[i][1];

answered May 31, 2016 at 2:53

boehm_s

5,5644 gold badges36 silver badges46 bronze badges

Comments

JonSG · Accepted Answer · 2016-05-31 02:55:39Z

1

Take the json from your spreadsheet and break it down and build it back up into an array of objects

var originalData = {
  "somerandomId" : "title: Test Title, gamelabel: Test Game, startdate: 2016-06-14",
  "someotherId" : "title: Test Title2, gamelabel: Test Game2, startdate: 2216-06-14"
};

var finalData = [];

for (var key in originalData) {
  var tmpData = {};

  originalData[key].split(",").forEach(function(item, index){
    var items = item.split(":");
    tmpData[items[0].trim()] = items[1].trim();
  });

  finalData.push(tmpData);
}

console.log(finalData);

answered May 31, 2016 at 2:55

JonSG

13.6k2 gold badges32 silver badges48 bronze badges

Comments

RobG · Accepted Answer · 2016-05-31 03:27:50Z

1

If you are confident of the structure, then split on colon and comma and use reduce to create the object:

var obj = {$t:'title: Test Title, gamelabel: Test Game, startdate: 2016-06-14'};

console.log(obj.$t.split(/[:,]/).reduce(function(acc, v, i, arr) {
    if (i%2) acc[arr[i-1].trim()] = v.trim();
    return acc;
  },{}));

Or if you're into obfuscated code (not recommended) and ECMAScript 2015 environment (not widely available yet):

var obj = {$t:'title: Test Title, gamelabel: Test Game, startdate: 2016-06-14'};
console.log(obj.$t.split(/[:,]/).reduce((acc,v,i,arr)=>i%2?(acc[arr[i-1].trim()]=v.trim())&&acc:acc,{}));

edited May 31, 2016 at 3:27

answered May 31, 2016 at 3:02

RobG

148k32 gold badges180 silver badges216 bronze badges

Comments

Pedro Lobito · Accepted Answer · 2016-05-31 03:21:26Z

0

Assuming the colon and commas have a pattern, you can use something like:

t = "title: Test Title, gamelabel: Test Game, startdate: 2016-06-14"
var rv = {};
for (var i = 0; i < t.split(/, /).length; ++i){
  rv[t.split(/, /)[i].split(/: /)[0]] = t.split(/, /)[i].split(/: /)[1];
}
console.log(rv)

edited May 31, 2016 at 3:21

answered May 31, 2016 at 3:05

Pedro Lobito

99.8k36 gold badges274 silver badges278 bronze badges

Collectives™ on Stack Overflow

Turning a string into a javascript object

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related