Remove Line Breaks and spaces From Json Object Keys typescript

Question

I have a Json object from Excel sheet conversion and it probably comes with some keys with Line breaks and spaces I want a function to remove all line breaks and spaces from json object keys This is the structure of the json

 {"SOH":[{"MN":"asdf","Part\r\nNumber":"1234"},{"MN":"asdf2","Part\r\nNumber":"12343"}]}

expected outcome

 {"SOH":[{"MN":"asdf","PartNumber":"1234"},{"MN":"asdf2","PartNumber":"12343"}]}

Thanks for support

have you tried regexes : jsonText.replace(/(\r\n|\n|\r)/gm, ""); ? — ShanieMoonlight
– ShanieMoonlight, Commented Feb 16, 2022 at 17:25

axtck · Accepted Answer · 2022-02-16 18:53:19Z

1

You could use Object.entries(), map() and replace() to recreate objects with replaced values.

const obj = {
  "SOH": [
    { "MN": "asdf", "Part\r\nNumber": "1234" },
    { "MN": "asdf2", "Part\r\nNumber": "12343" }
  ]
};

const result = {
   "SOH": obj.SOH.map(o => {
      return Object.fromEntries(Object.entries(o).map(([k, v]) => [k.replace(/(\n|\s)/g, ""), v]));
   })
};
console.log(result);

Or if you want to make it more dynamic.

const obj = {
   "SOH": [
      { "MN": "asdf", "Part\r\nNumber": "1234" },
      { "MN": "asdf2", "Part\r\nNumber": "12343" }
   ],
   "MOH": [
      { "MN": "asdf", "Part\r\nNumber": "1234" },
      { "MN": "asdf2", "Part\r\nNumber": "12343" }
   ],
   "KOH": [
      { "MN": "asdf", "Part\r\nNumber": "1234" },
      { "MN": "asdf2", "Part\r\nNumber": "12343" }
   ]
};

const result = Object.fromEntries(Object.entries(obj).map(([k, v]) => {
   return [k, v.map(x => Object.fromEntries(Object.entries(x).map(([kk, vv]) => [kk.replace(/(\n|\s)/g, ""), vv])))]
}));

console.log(result);

edited Feb 16, 2022 at 18:53

answered Feb 16, 2022 at 17:26

axtck

3,9753 gold badges17 silver badges32 bronze badges

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

7 Comments

ABM Over a year ago

Hi, the problem with my in keys not value

axtck Over a year ago

You could change Object.values to Object.keys

ABM Over a year ago

This is the structure of the json object how to access the key {"SOH":[{"MN":"asdf","Part\r\nNumber":"1234"},{"MN":"asdf2","Part\r\nNumber":"12343"}]}

ABM Over a year ago

I want to modify the key and the value remains the same

ABM Over a year ago

{"SOH":[{"MN":"asdf","PartNumber":"1234"},{"MN":"asdf2","PartNumber":"12343"}]}

|

Collectives™ on Stack Overflow

Remove Line Breaks and spaces From Json Object Keys typescript

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related