ansaurus

Question

remove quotes from keys in a json string using jquery...

Answer 1

+1 A:

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.

patrick dw 2010-09-06 12:18:29

@patrick if possible go through this http://www.hugoware.net/Projects/jLinq and see the data.users

Pandiya Chendur 2010-09-06 12:21:01

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

patrick dw 2010-09-06 12:28:10

@patrick now see this http://stackoverflow.com/questions/3636568/jlinq-doesnt-seem-to-fetch-all-matching-rows-from-my-json-data i ve tried the same what you said but it doesn't filter my json data?

Pandiya Chendur 2010-09-06 12:31:01

@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.

patrick dw 2010-09-06 12:36:39

Answer 2

+1 A:

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, but won't that cuz a problem if the label was a reserved word?

aularon 2010-09-06 12:18:45

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

patrick dw 2010-09-06 12:38:23

@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!"`

aularon 2010-09-06 12:56:53

That's my point. It won't match it.

patrick dw 2010-09-06 13:02:54

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

patrick dw 2010-09-06 13:07:17

@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.

aularon 2010-09-06 13:07:20

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.

patrick dw 2010-09-06 13:27:37

ansaurus

tags:

views:

answers:

remove quotes from keys in a json string using jquery...

related questions