Cannot loop regex value in JSON data using jquery

Question

0.00/5 (No votes)

See more:

Below is my JSON data from asp.net web service

d:"[{"ID":"2","Name":"Office Address","Desc":"Office Address","Check":"True","Code":"/^[a-zA-Z0-9\s\:\-]+$","CreatedBy":"felixd","CreatedDateTime":"2/18/2017 8:05:24 PM","UpdatedBy":"","UpdatedDateTime":"","IsActive":"True","ActiveStatus":"Yes","FlagStatus":"Yes"}]"

while trying to iterate the data using below jquery ajax success code

success: function (response) {
  if (response.d != '') {
    var list = JSON.parse(response.d);
    $.each(list, function (k, v) {
      console.log(response.d[k].ID);
    });
   }
},
error: function(response){}

I get the following error

Quote:
Uncaught SyntaxError: Unexpected token s in JSON at position 95
at JSON.parse (<anonymous>)
at Object.success (MasterList.aspx:49)
at fire (jquery-1.12.4.js:3232)
at Object.fireWith [as resolveWith] (jquery-1.12.4.js:3362)
at done (jquery-1.12.4.js:9840)
at XMLHttpRequest.callback (jquery-1.12.4.js:10311)
success @ AddressTypeList.aspx:49
fire @ jquery-1.12.4.js:3232
fireWith @ jquery-1.12.4.js:3362
done @ jquery-1.12.4.js:9840
callback @ jquery-1.12.4.js:10311

how to resolve this error?
Please advise
Thanks

What I have tried:

I tried remove the JSON.parse

I get following error

Uncaught TypeError: Cannot use 'in' operator to search for 'length' in [{"ID":"2","Name":"Office Address","Desc":"Office Address","Check":"True","Code":"/^[a-zA-Z0-9\s\:\-]+$","CreatedBy":"felixd","CreatedDateTime":"2/18/2017 8:05:24 PM","UpdatedBy":"","UpdatedDateTime":"","IsActive":"True","ActiveStatus":"Yes","FlagStatus":"Yes"}]
    at isArrayLike (jquery-1.12.4.js:569)
    at Function.each (jquery-1.12.4.js:367)
    at Object.success (MasterList.aspx:50)
    at fire (jquery-1.12.4.js:3232)
    at Object.fireWith [as resolveWith] (jquery-1.12.4.js:3362)
    at done (jquery-1.12.4.js:9840)
    at XMLHttpRequest.callback (jquery-1.12.4.js:10311)

Posted 18-Feb-17 4:47am

Christopher Fernandes

Updated 18-Feb-17 7:34am

Add a Solution

Comments

Karthik_Mahalingam 18-Feb-17 11:45am

the given json looks fine.

Christopher Fernandes 18-Feb-17 13:24pm

it breaks at \s in the regex value. it cant escape the \s

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2017-02-18T07:31:00

Solution 2

try this

var jsonstr = JSON.stringify(response.d);
var json = JSON.stringify(jsonstr);

Posted 18-Feb-17 7:31am

Karthik_Mahalingam

Bryian Tan · Answer 2 · 2017-02-18T07:34:00

These two lines doesn't seem right

JavaScript

d:"[{"ID":"2","Name":"Office Address","Desc":"Office Address","Check":"True","Code":"/^[a-zA-Z0-9\s\:\-]+$","CreatedBy":"felixd","CreatedDateTime":"2/18/2017 8:05:24 PM","UpdatedBy":"","UpdatedDateTime":"","IsActive":"True","ActiveStatus":"Yes","FlagStatus":"Yes"}]"
console.log(response.d[k].ID);

If you notice that, d is a string, and you can't access the string using key value.

On the other hand if d is an array, then the code will work

JavaScript

var d =[{"ID":"2","Name":"Office Address","Desc":"Office Address","Check":"True","Code":"/^[a-zA-Z0-9\s\:\-]+$","CreatedBy":"felixd","CreatedDateTime":"2/18/2017 8:05:24 PM","UpdatedBy":"","UpdatedDateTime":"","IsActive":"True","ActiveStatus":"Yes","FlagStatus":"Yes"}];
console.log(d[0].ID);

Just like Peter pointed out, the code need JSON.parse. See below on how to access the value after the parse

JavaScript

var data = JSON.parse(d);
$.each(data, function(i, item) {
    x +='ID: ' + item["ID"] + '<br/>Name: ' + item["Name"];
    console.log(item["ID"]);
});

Here is an example.
https://jsfiddle.net/0hnkznqq/2/

basically the d in this example = response.d

Cannot loop regex value in JSON data using jquery

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us