Extracting JSON from string

Question

I am getting a string from server and want to extract Json string from it here is the string

<?xml version="1.0" encoding="utf-8"?>
    <string xmlns="http://tempuri.org/">
      [{"isAssigned": false,"Name": "c:\\inetpub\\wwwroot\\XLEZ\\CLIENT","LastModified": ""},
    {"isAssigned": true,"Name": "\\mokuji.html","LastModified": "20140806 165709"},
    {"isAssigned": false,"Name": "\\result.html",{"LastModified": "20131002 235302"}]
    </string>

I am not being able to figure out how to do it... Here is JSFiddle

You could try $.parseXML and then get the string string element in the XML. — Danny
– Danny, Commented Aug 8, 2014 at 13:52
@Quentin I know its just for reference actual data has valid json but its in those xml tags i want to get rid of these tags — AddyProg
– AddyProg, Commented Aug 8, 2014 at 13:56
@AdilWaqar — If it contained valid JSON then people could fork it to test and demo code without having to fix your sample data first. — Quentin
– Quentin, Commented Aug 8, 2014 at 13:57

Community · Accepted Answer · 2017-05-23 10:34:05Z

3

Based on this via Convert XML to JSON (and back) using Javascript

I did this:

Live Demo

No error handling

function parseXml(xml) {
  var dom = null;
  if (window.DOMParser) {
    try {
        dom = (new DOMParser()).parseFromString(xml, "text/xml");
    } catch (e) {
        dom = null;
    }
  } else if (window.ActiveXObject) {
    try {
        dom = new ActiveXObject('Microsoft.XMLDOM');
        dom.async = false;
        if (!dom.loadXML(xml)) // parse error ..

        window.alert(dom.parseError.reason + dom.parseError.srcText);
    } catch (e) {
        dom = null;
    }
  } else alert("cannot parse xml string!");
  return dom;
}


function extractJson() {
  var xml = '<?xml version="1.0" encoding="utf-8"?><string xmlns="http://tempuri.org/">[ {"x":"y"},{"a":"b"}]</string>';
  var json = JSON.parse(parseXml(xml).firstChild.textContent);
  console.log(json)
}

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Aug 8, 2014 at 14:07

mplungjan

180k29 gold badges183 silver badges246 bronze badges

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

2 Comments

JAAulde Over a year ago

This solution provides the best options for parsing XML in multiple browser environments, as well as the best DOM navigation practices.

mplungjan Over a year ago

I guess I should also have posted the jQuery I did not post because it was not tagged jQuery :/

davidmdem · Accepted Answer · 2014-08-08 14:09:04Z

2

If you are not opposed to using jQuery, it handles traversing and extracting data from XML strings just as well as HTML strings.

You can pull the JSON string like so

    // Get JSON string out
    var extractedJson = $(jsonData).text();

    // If you need it as an object
    var extractedJsonAsObject = $.parseJSON(extractedJson);

Here is a working example of your Fiddle:

http://plnkr.co/edit/nfnjreyfv0adIZ6Ue1Ox?p=preview

answered Aug 8, 2014 at 14:09

davidmdem

3,8232 gold badges33 silver badges34 bronze badges

3 Comments

JAAulde Over a year ago

This assumes that the XML will never contain anything other than a single element with JSON, and no whitespace. I suspect the OP's example was quite simple for the sake of brevity, and that the actual XML in the wild may be more complex.

davidmdem Over a year ago

Fair enough. I assumed that they could pick it up from there. CSS selectors for traversing the XML document also work the same as they do traversing HTML.

JAAulde Over a year ago

Yeah, I hear ya. I just wanted the OP to understand he may need to do a little more in case it wasn't obvious to him.

Pal Singh · Accepted Answer · 2014-08-08 14:16:20Z

1

You could simply parse the XML and get its content

function extractJson()
{

var jsonData = '<?xml version="1.0" encoding="utf-8"?><string xmlns="http://tempuri.org/">[ {'sone': 'json'},{'some': 'json2'}]</string>';
    var parser = new DOMParser();
 var xmlDoc = parser.parseFromString(jsonData,"text/xml");
console.log(xmlDoc.getElementsByTagName('string')[0].innerHTML);    
}
extractJson();

Note: Internet Explorer uses the loadXML() method to parse an XML string, while other browsers use the DOMParser object.

edited Aug 8, 2014 at 14:16

answered Aug 8, 2014 at 14:02

Pal Singh

1,9721 gold badge17 silver badges32 bronze badges

Comments

webNeat · Accepted Answer · 2014-08-08 14:04:31Z

-2

Assuming Json doesn't contains tags, you can just replace all xml tags with empty string (ie remove them) like this:

function extractJson(){
    var jsonData = '<?xml version="1.0" encoding="utf-8"?><string xmlns="http://tempuri.org/">[ {sonejson},{some json2}]</string>';
    var extractdJson = jsonData.replace(/\<[^\>]+\>/gi,''); // extracted jason fron jsonData 
    alert(extractdJson);    
}

Hope this helps

answered Aug 8, 2014 at 14:04

webNeat

2,8661 gold badge22 silver badges25 bronze badges

4 Comments

JAAulde Over a year ago

You should really avoid using anything but an actual parser to work with, and extract data from, markup.

webNeat Over a year ago

If JSON will not contain any xml tags, then this will be more simple and fast then using a parser.

JAAulde Over a year ago

I disagree wholeheartedly. Furthermore, if your solution requires caveats and conditions to be useful, you can be sure those caveats and conditions will be violated in the wild.

webNeat Over a year ago

The solution should be general or it's not useful yeah

Collectives™ on Stack Overflow

Extracting JSON from string

4 Answers 4

2 Comments

3 Comments

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

3 Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related