Pulling second column only from XML into array

Question

I'm trying to pull in an external file which contains only 2 columns but several rows, the first is just a numeric reference in ascending order and should be just skipped but the second contains value which I need to push into an array so they can be injected into the page. So far all I can get it to do is pull in all the values.

var catalogIn = [];

$.ajax({
    url: 'content-catalog.xml',
    type: 'GET',
    dataType: 'xml',
    success: function (returnedXMLResponse) {
        $(returnedXMLResponse).find('Row').each(function () {
            // loop over each cell
            $('Data', this).each(function () {
                // push row into main array
                catalogIn.push($(this).text());
            });
        })
    }
});

Please see "Should questions include “tags” in their titles?", where the consensus is "no, they should not"! — user57508
– user57508, Commented Dec 9, 2015 at 11:53

Navoneel Talukdar · Accepted Answer · 2015-12-09 11:54:59Z

1

First of all you need to parse the xml response like

var xmlresponse = $.parseXML(returnedXMLResponse);

Then find a node by looping the xmlresponse.

var $xml = $(xmlresponse);
var $data = $xml.find("<your node>");

$data.each(function(){

    var column1= $(this).find('your column 1').text(),
     var column2= $(this).find('your column 2').text(); 
});

answered Dec 9, 2015 at 11:54

Navoneel Talukdar

4,6365 gold badges24 silver badges43 bronze badges

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

Comments

Mazhar Qayyum · Accepted Answer · 2015-12-09 12:17:58Z

0

Why not check against column index then decide if you should add the element to array or not

var catalogIn = [];

$.ajax({
    url: 'content-catalog.xml',
    type: 'GET',
    dataType: 'xml',
    success: function (returnedXMLResponse) {
        $(returnedXMLResponse).find('Row').each(function () {
            // loop over each cell
            $('Data', this).each(function (index) {
                if(index == 1) {
                // push row into main array
                catalogIn.push($(this).text());
                }
            });
        })
    }
});

answered Dec 9, 2015 at 12:17

Mazhar Qayyum

6307 silver badges23 bronze badges

Collectives™ on Stack Overflow

Pulling second column only from XML into array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related