How to loop through jquery objects in an array and display the desired result?

Question

I m newbie in jquery space and hope to learn much through Stackoverflow.

I have a Sharepoint 2010 list data item which has Choice data type allowing a user to checkbox more than one value. I m using SPService to get the list items. Below is the code:

    $().SPServices({
                  webURL: 'http://abc.def.com/Products',
                  operation: 'GetListItems',
                  listName: listName,
                  async: false,
                  CAMLQuery: query,
                  CAMLViewFields: fields,
                  CAMLRowLimit: 11,

                  completefunc:
                  function (xData, Status) 
    {        $(xData.responseXML).find("[nodeName=z:row]").each(function () 

    {
           $("#ProdList").val("-1");//Pre-filled with selected val.
           var myProd= $(this).attr("ows_Prod"); //displays in this format ;#myProd1;#myProd2;#

          //Here 1. i want to store myProd as an array.
                 2. eliminate ;#
                 3. store final array elements as myProd1, myProd2
                 4. Display myProd1
                            myProd2
                                    in the dropdown list.
           //


           $("#ProdList").append('<option>' + myProd+ '</option>');
      });   
    }

     });      

     });

    <body>
    <select class="Dropdowns" id="ProdList">
    <option value="-1">My ProdLists</option>
    </select>
    </body>
  Any pointers? Thanks.

jfriend00 · Accepted Answer · 2011-10-27 22:25:38Z

1

It's a bit hard to figure out what the specifics are of your question. I'm guessing that the comments in your code are describing the question. Next time, I'd suggest you be a lot more specific with the details of your question in your text, not in the code. But, given that, here's my guess at what you're trying to do.

You have a string that looks like this:

";#myProd1;#myProd2;#"

And, you'd like to get myProd1 and myProd2 into an array and then from that array added to a drop-down list.

// get product list
var myProd = $(this).attr("ows_Prod");
// clean up the ends
myProd = myProd.replace(/^;#|;#$/g, "");
// split into pieces
var myProdArray = myProd.split(";#");
// add each piece as an option to the drop-down
for (var i = 0; i < myProdArray.length; i++) {
    $("#ProdList").append('<option>' + myProdArray[i] + '</option>')
}

You can sort the array in dictionary order with:

myProdArray.sort();

You can remove dups from a sorted array with this:

var noDupArray = [];
noDupArray.push(myProdArray[0]);
for (var i = 1; i < myProdArray.length; i++) {
    if (myProdArray[i] != myProdArray[i-1]) {
        noDupArray.push(myProdArray[i]);
    }
}

So, if you wanted to both sort and remove dups, you could use this code:

var myProd = $(this).attr("ows_Prod");
myProd = myProd.replace(/^;#|;#$/g, "");
var myProdArray = myProd.split(";#");
// sort
myProdArray.sort();
// remove dups
var noDupArray = [];
noDupArray.push(myProdArray[0]);
for (var i = 1; i < myProdArray.length; i++) {
    if (myProdArray[i] != myProdArray[i-1]) {
        noDupArray.push(myProdArray[i]);
    }
}
// add each piece as an option to the drop-down
for (i = 0; i < noDupArray.length; i++) {
    $("#ProdList").append('<option>' + noDupArray[i] + '</option>')
}

edited Oct 27, 2011 at 22:25

answered Oct 25, 2011 at 4:32

jfriend00

711k104 gold badges1.1k silver badges1k bronze badges

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

17 Comments

GSGS Over a year ago

Thanks a bunch jfriend00. It worked. I will definitely try to be more specific in describing a question next time. Thanks again for your help. :)

GSGS Over a year ago

How do I make sure that I don't have duplicates in my dropdown list for the above code? I also want my myProdArray to be sorted (ASC). Any pointers? Thanks.

jfriend00 Over a year ago

Sorting and dedupping added to my answer.

GSGS Over a year ago

I have two list items and they have same values for myProd.For eg. let's say SharePoint2010 I have to make sure I only put SharePoint 2010 once in the dropdown list. With the code above, I could not eliminate the duplicacy. Any guidance please? Thanks a lot for prompt response.

jfriend00 Over a year ago

It seems to work fine here in this sample jsfiddle.net/jfriend00/yCauH if implemented as above. There are multiple dups in the attribute, but no dups are put in the drop-down. If you want further help, you'll have to show your actual implementation.

|

Collectives™ on Stack Overflow

How to loop through jquery objects in an array and display the desired result?

1 Answer 1

17 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

17 Comments

Your Answer

Sign up or log in

Post as a guest

Related