remove quotes from keys in a json string using jquery

Question

Consider this as my json string,

{"Table" : [{"userid" : "11","name" : "KumarP","designation" : "Business Head",
"phone" : "9789234793","email" : "[email protected]","role" : "Admin",
   "empId" : "EI003","reportingto" : "KumarP"}]}

and i want to have my string like this,

{Table:[{ userid: "11", name: "KumarP", designation: "Business Head", 
    phone: "9789234793", email:"[email protected]", role : "Admin",
       empId : "EI003",reportingto : "KumarP"}]}

I am doing so to use it with jlinq..

Think you should go with a regular expression, searching for words before the ':'. — Peter Kiers
– Peter Kiers, Commented Sep 6, 2010 at 12:08
@GenericTypeTea and @Hogan i am trying to filter my json data clientside with a library like jlinq. It uses the latter type of json string hugoware.net/Projects/jLinq — ACP
– ACP, Commented Sep 6, 2010 at 12:12
We are suffering the same problem in PHP Symfony. json_encode() quotes json hash keys, which later Google Charts developers.google.com/chart/interactive/docs/… errors out with c[qe] is not a function — Marcos
– Marcos, Commented Nov 12, 2014 at 9:33

aularon · Accepted Answer · 2013-11-16 00:01:18Z

28

Use Regular Expressions:

var a='{"Table" : [{"userid" : "11","name" : "KumarP","designation" : "Business Head","phone" : "9789234793","email" : "[email protected]","role" : "Admin",    "empId" : "EI003","reportingto" : "KumarP"}]}';
a=a.replace(/"(\w+)"\s*:/g, '$1:');
alert(a);

The string will become as your second codeblock:

{Table: [{userid: "11",name: "KumarP",designation: "Business Head",phone: "9789234793",email: "[email protected]",role: "Admin",    empId: "EI003",reportingto: "KumarP"}]}

But won't that cause a problem if the label was a reserved word?

edited Nov 16, 2013 at 0:01

answered Sep 6, 2010 at 12:18

aularon

11.1k4 gold badges38 silver badges41 bronze badges

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

5 Comments

user113716 Over a year ago

What if one of the keys or values has a : in it? Using a JSON parser would be a safer approach.

aularon Over a year ago

@patrick, it won't match them, cuz the regular expression specifies double quotes, and a \w+, so it will neither match a "my name is: john" nor "my name is: \"john\": the coder!"

user113716 Over a year ago

I guess I shouldn't have been so specific with :. Any non \w character will cause the match to fail.

aularon Over a year ago

@patrick That's my point too :)! I don't want it to match inside values! and for keys I know it won't match keys with weird names, I said but won't that cuz a problem if the label was a reserved word? in my post. BTW the examples in my previous comment are examples for values, not keys.

user113716 Over a year ago

Yes, you're right about the values. Not sure why I included that. I see what you mean about the reserved word. Even worse, simply getting rid of the quotes around the keys (like OP requested) would turn a valid JSON string into an invalid one, regardless of reserved words. I think OP was requesting a way to implement a solution that doesn't fix the actual issue.

user113716 · Accepted Answer · 2010-09-06 12:18:29Z

9

If what you have is actually a JSON string, as in:

var obj = '{"Table" : [{"userid" : "11","name" :"KumarP","designation" : "Business Head",\
"phone" : "9789234793","email" : "[email protected]","role" : "Admin",\
"empId" : "EI003","reportingto" : "KumarP"}]}';

Then you could parse it with $.parseJSON(), as in:

var result = $.parseJSON( obj );

This will convert your JSON string to javascript objects/arrays.

answered Sep 6, 2010 at 12:18

user113716

323k64 gold badges454 silver badges441 bronze badges

4 Comments

ACP Over a year ago

if possible go through this hugoware.net/Projects/jLinq and see the data.users

user113716 Over a year ago

@Pandiya - I see it, but what about it should I see?

ACP Over a year ago

now see this stackoverflow.com/questions/3636568/… i ve tried the same what you said but it doesn't filter my json data?

user113716 Over a year ago

@Pandiya - I don't know how you're creating/receiving the data. Is it actually a JSON string? If you're creating a object like: var obj = {"hi","there"};, then the quotes won't hurt anything. But if it is a JSON string like: var obj = '{"hi","there"}';, then using $.parseJSON() will convert it to the first version. You should log your data to the console both ways to see if it is what you expect.

Collectives™ on Stack Overflow

remove quotes from keys in a json string using jquery

2 Answers 2

5 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related