Copy certain key:value pair(s) in a JSON array to a new array


I have a JSON array passed back to javaScript from a PHP / MS-SQL table extraction.   The table has 100 fields and 2,000 records so the JSON array has 100 "key":"value" pairs and 2,000 rows.

From this JSON array In javaScript, I would like to create another JSON array of all 2,000 rows from it, but with only 2 of its 100 key:value pairs. These two for example (ItemCode and ItemName):

{"ItemCode" : "1234567", "ItemName" : "Widget", "...." : "....", }, { .... }

How can I do that in javaScript?

Another question:

How can I do it being sure there are no duplicates of the 2 key:value pairs in the new array?
Joe WeinpertSr Application Engineer & DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David S.Commented:
Do you actually use any of the rest of the information in your JS? It seems incredibly inefficient to transfer all of that data for each page request, to only use a little of it.

Anyway, to answer your question, you use a for loop to build a new array or a for-in loop to build a new object (called an "associative array" in other languages).

As to duplicates keys, if there are any, they will overwrite the previous, unless you add additional code to handle that differently.

var myArray2=[];
for(var i=0,k=myArray.length; i<k; i++) {

Open in new window

var myObject2={};
for(var key in myObject) {

Open in new window

Edit: Typo in code corrected.
Joe WeinpertSr Application Engineer & DeveloperAuthor Commented:
Oh yes, all of the fields extracted from tables are used in jQWidgets grids.  The purpose of this scenario is to extract just the ItemCode and Description from the main grid to use in a drop-down list.

As to your code, I understand the requirement to loop, but not what you mean by the word key in the first example, or why line 3

Open in new window

is changing the source array.
David S.Commented:
I see. Thanks for explaining.

Oh, that was a typo (and I forgot to change "key" to "i" in that example). That line should be:

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Joe WeinpertSr Application Engineer & DeveloperAuthor Commented:
Ok ... thanks for the input.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.