Tips for filtering an array based on a specific condition:

Question

Tips for filtering an array based on a specific condition:

I am working with an array:

results = [
  {"Created Date ": "20181012", "Created By ": "A", "Job Number ": "001", "Department": "FS"},
  {"Created Date ": "20181012", "Created By ": "B", "Job Number ": "002", "Department": "DS"},
  {"Created Date ": "20181012", "Created By ": "C", "Job Number ": "004", "Department": "FS"}
]

The values in the array might look like this sometimes (column order changed and no blank characters, but column names remain consistent):

results = [
  {"Created By": "A", "Department": "FS", "Created Date": "20181012", "Job Number": "001" },
  {"Created By": "B", "Department": "DS", "Created Date": "20181012", "Job Number": "002"},
  {"Created By": "C", "Department": "FS", "Created Date": "20181012", "Job Number": "004"}
]

Now, I want to extract a new array that includes only the values of three specific columns - "Created By", "Created Date", and "Job Number", in a specific order. The resulting array should look like this:

results = [
  {"20181012", "A", "001"},
  {"20181012", "B", "002"},
  {"20181012", "C", "004"}
]

Do you have any suggestions on how to achieve this?

javascript arrays

Answer 1

Answer №1

It is important to note that objects do not have a reliable ordering, so the concept of a first or second column is irrelevant.

However, if you have specific keys for which you need the corresponding values, you can utilize the map function and consider variations of the key to account for any discrepancies:

var results = [{
    "Created Date ": "20181012",
    "Created By ": "A",
    "Job Number ": "001",
    "Department": "FS"
  },
  {
    "Created Date": "20181012",
    "Created By ": "B",
    "Job Number ": "002",
    "Department": "DS"
  },
  {
    "Created Date": "20181012",
    "Created By ": "C",
    "Job Number ": "004",
    "Department": "FS"
  }
]

var output = results.map(d => [
  d['Created Date'] || d['Created Date '],
  d['Created By'] || d['Created By '],
  d['Job Number'] || d['Job Number ']
]);

console.log(output);

Answer 2

It is important to note that objects do not have a reliable ordering, so the concept of a first or second column is irrelevant.

However, if you have specific keys for which you need the corresponding values, you can utilize the map function and consider variations of the key to account for any discrepancies:

var results = [{
    "Created Date ": "20181012",
    "Created By ": "A",
    "Job Number ": "001",
    "Department": "FS"
  },
  {
    "Created Date": "20181012",
    "Created By ": "B",
    "Job Number ": "002",
    "Department": "DS"
  },
  {
    "Created Date": "20181012",
    "Created By ": "C",
    "Job Number ": "004",
    "Department": "FS"
  }
]

var output = results.map(d => [
  d['Created Date'] || d['Created Date '],
  d['Created By'] || d['Created By '],
  d['Job Number'] || d['Job Number ']
]);

console.log(output);

Answer 3

Answer №2

This example showcases an alternative approach to using the map() method of an Array object:

var results = [{
"Created Date ": "20181012",
"Created By ": "A",
"Job Number ": "001",
"Department": "FS"
  },
  {
"Created Date": "20181012",
"Created By": "B",
"Job Number": "002",
"Department": "DS"
  },
  {
" Created Date": "20181012",
" Created By": "C",
" Job Number": "004",
"Department": "FS"
  }
];

Array.prototype.remove = function(index){
  this.splice(index,1);
}

var nu_arry = results.map(item => {
  let d = [];
  let keys = Object.keys(item);
  keys.remove(3);  // remove Department key name
  keys.forEach(function(key) {
    d.push(item[key]);
  });
  return d;
});
console.log(nu_arry);

Regardless of spaces before or after a key name, the code effectively identifies all keys using Object.keys(). The flexibility of this solution allows for easy modification of key names without impacting functionality, as there are no hardcoded keys. Note: the use of arrow functions eliminates the need for separate user-defined functions.

Answer 4

This example showcases an alternative approach to using the map() method of an Array object:

var results = [{
"Created Date ": "20181012",
"Created By ": "A",
"Job Number ": "001",
"Department": "FS"
  },
  {
"Created Date": "20181012",
"Created By": "B",
"Job Number": "002",
"Department": "DS"
  },
  {
" Created Date": "20181012",
" Created By": "C",
" Job Number": "004",
"Department": "FS"
  }
];

Array.prototype.remove = function(index){
  this.splice(index,1);
}

var nu_arry = results.map(item => {
  let d = [];
  let keys = Object.keys(item);
  keys.remove(3);  // remove Department key name
  keys.forEach(function(key) {
    d.push(item[key]);
  });
  return d;
});
console.log(nu_arry);

Regardless of spaces before or after a key name, the code effectively identifies all keys using Object.keys(). The flexibility of this solution allows for easy modification of key names without impacting functionality, as there are no hardcoded keys. Note: the use of arrow functions eliminates the need for separate user-defined functions.

Tips for filtering an array based on a specific condition:

Answer №1

Answer №2

Similar questions

Enhance your Google Line Chart by incorporating HTML into the tool tip feature

What is the technique for adjusting the background while rotating the corner?

Transferring information from a React Native user interface to an Express server

What is the best way to modify the Angular ng-src output to use the 'data-src' attribute instead of 'src'?

Performing repeated insertion using a foreach loop

The Google map is missing from view, but the search box is visible

"Converting an array within a single object into an object: step-by-step

Updating model values while dragging with Angular Dragular

When utilizing JSON data in node.js, the .find() method may return undefined

Which is more efficient for selecting population data: using Ajax to request a JSON Object or echoing HTML directly?

Guidelines on populating a Vue array with data fetched from an Axios request

Leveraging a JSON file as a data repository for chart.js

The Bootstrap navbar stubbornly refuses to hide after being clicked on

Ensure that there are no empty values within a nested object

Generating a dynamic drop-down menu in Django using database values

When attempting to implement sound on hover with an <a attribute containing an image>, the functionality is not functioning as expected

Text is misaligned with the cursor position

Arrange pictures into an array and showcase them

Attempting to retrieve key-value pairs from a nested JSON array

Unable to call upon JavaScript code from an external file