How can i replace all special characters in a string in nodejs using replace?

Question

experience(years)d.o.b (dd/mm/yyyy) -- how can I remove (),.,/, spaces from the string using single replace function in node. I would like to get like

experienceyearsdobddmmyyyy

//pgm converts xl to json

const exceltojson = require('xlsx-to-json');
const fs = require('fs');
exceltojson({
    input: "xl.xlsx",
    output: 'xl.txt',// Don't need output
    sheet: 'student_Details'
  },
  function(err, result) {
    if (err) {
      console.error(err);
      return;
    }
    else{
      console.log(result+'   result')
      console.log(result)
    }
    const newResult = result.map(obj => {
      const newObj = Object.keys(obj).reduce((acc, key) => {
        const newKey = key.replace(/ /g, '').toLowerCase();
        acc[newKey] = obj[key];
        console.log(newKey+'   newKey ')
        return acc;
      }, {});
      return newObj;
    });
    fs.writeFileSync('xl.json', JSON.stringify(newResult));
  }
)

please add the current working code with actual output and desired output — anees
– anees, Commented May 5, 2020 at 18:23
the above code converts excel to json and make all the headers in lowercase and remove spaces, but I would also like to remove special charcters from my keys — learnNcode
– learnNcode, Commented May 5, 2020 at 18:28

Mark Paine · Accepted Answer · 2020-05-05 18:31:07Z

3

> re = /[\(\)\/\.\ ]+/g
/[\(\)\/\.\ ]+/g
> s="(10/04/2020)"
'(10/04/2020)'
> s.replace(re, "")
'10042020'

answered May 5, 2020 at 18:31

Mark Paine

1,88413 silver badges14 bronze badges

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

Comments

anees · Accepted Answer · 2020-05-05 18:31:03Z

2

you can use regex to replace all those chracters.

let str = "experience(years)d.o.b (dd/mm/yyyy)";

function stripedStr(s){
  return s.replace(/[\(,\),\.,\/,\-,\_, ,]/g, "");
}

console.log(stripedStr(str));

answered May 5, 2020 at 18:31

anees

1,8853 gold badges20 silver badges27 bronze badges

Collectives™ on Stack Overflow

How can i replace all special characters in a string in nodejs using replace?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related