Home > OS >  Filter Object by key and value
Filter Object by key and value

Time:10-12

Is there anyway to filter an object conditionally checking both the key and value? What I am trying to do is check if the key equals a string and check whether or not the value is empty.

I am trying to detect whether or not Teaching Hospital has an empty value, but Teaching Hospital Tax ID does not and vice-versa. If Teaching Hospital Name has a value, but Teaching Hospital Tax ID does not, the returned result should be: {Teaching Hospital Tax ID: ""}.

Object

{
  'Manufacturer Name': 'Ascendis',
  'HCP First Name': 'John',
  'HCP Middle Name': '',
  'HCP Last Name': '',
  'HCP NPI': 2442,
  'HCP Credentials': '',
  'HCP State License Number': '',
  'HCP State of Licensure': '',
  'HCP Specialty': '',
  'Teaching Hospital Name': 'Trinity',
  'Teaching Hospital Tax ID': '',
  'Address 1': '',
  'Address 2': '',
  'Postal Code': '',
  'Spend Date': '',
  'Spend Currency': '',
  'Spend Amount': '',
  'Form of Payment': '',
  'Nature of Payment': '',
  'Home System Identifier': '',
  'Product Name': '',
  'Travel City': '',
  'Travel State': '',
  'Travel Country': ''
}

Code

Object.entries(item)
          .filter(([key, value]) => (key === "Teaching Hospital Name" && value != "") && (key === "Teaching Hospital Tax ID" && value === ""))

CodePudding user response:

Use || instead of &&:

const obj = {
  'Manufacturer Name': 'Ascendis',
  'HCP First Name': 'John',
  'HCP Middle Name': '',
  'HCP Last Name': '',
  'HCP NPI': 2442,
  'HCP Credentials': '',
  'HCP State License Number': '',
  'HCP State of Licensure': '',
  'HCP Specialty': '',
  'Teaching Hospital Name': 'Trinity',
  'Teaching Hospital Tax ID': '',
  'Address 1': '',
  'Address 2': '',
  'Postal Code': '',
  'Spend Date': '',
  'Spend Currency': '',
  'Spend Amount': '',
  'Form of Payment': '',
  'Nature of Payment': '',
  'Home System Identifier': '',
  'Product Name': '',
  'Travel City': '',
  'Travel State': '',
  'Travel Country': ''
}

Object.entries(obj).forEach(([key, value]) => {
    if ((key === "Teaching Hospital Name" && value != "") || (key === "Teaching Hospital Tax ID" && value === "")) {
        delete obj[key]
    }
})

console.log(obj)

CodePudding user response:

You can use Array.prototype.reduce to create a new object with the select properties removed:

Object.entries(obj).reduce((acc, [key, value]) => {
  if (
    (key === "Teaching Hospital Name" && value !== "") ||
    (key === "Teaching Hospital Tax ID" && value === "")
  ) {
    // do not add key/value to resulting object
    return { ...acc };
  }

  return { ...acc, [key]: value };
}, {});

This avoids mutating the original object.

CodePudding user response:

Lets see if below code works for you

const obj = {
  'Manufacturer Name': 'Ascendis',
  'HCP First Name': 'John',
  'HCP Middle Name': '',
  'HCP Last Name': '',
  'HCP NPI': 2442,
  'HCP Credentials': '',
  'HCP State License Number': '',
  'HCP State of Licensure': '',
  'HCP Specialty': '',
  'Teaching Hospital Name': 'Trinity',
  'Teaching Hospital Tax ID': '',
  'Address 1': '',
  'Address 2': '',
  'Postal Code': '',
  'Spend Date': '',
  'Spend Currency': '',
  'Spend Amount': '',
  'Form of Payment': '',
  'Nature of Payment': '',
  'Home System Identifier': '',
  'Product Name': '',
  'Travel City': '',
  'Travel State': 'nonempty',
  'Travel Country': ''
}
function check(obj, groupArr) {
  const group = new Set(groupArr);
  const vals = Object.entries(obj).filter(([key, value]) => group.has(key) && value === "");
  if(vals.length === group.size || vals.length === 0) return false;
  return Object.fromEntries(vals);
}
console.log(check(obj, ["Travel City", "Travel State", "Travel Country"]));
/* results
{
   "Travel City": "",
   "Travel Country": ""
}
*/

  • Related