How do I remove commas, spaces and dots from the string.

Question

1.00/5 (1 vote)

See more:

I want to save Excel data to the database but the problem is before inserting it into the database remove all the commas, dots and spaces from the string.By using Regex i want a function which can give me below output.

for example :-1.string contains P G it saves PG or P,. G returns PG
2. if the string is Workshop Related Expenses the output is same in that case i dont want remove spaces.

if the string is single then remove spaces, commas and dots but when it is sentence remove commas and dots.

What I have tried:

function convertString(d) {
        if (typeof d === "string") {
          let regex = /[^a-zA-Z ]/g;
          let newString= d.replace(regex, "");
          d = newString;
        }
        return d;
      }

Posted 6-Apr-23 6:47am

Member 15926609

Updated 18-Apr-23 20:11pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2023-04-07T02:52:00

Your regex excludes spaces, and includes all punctuation as well as numeric characters. To remove commas, dots, and spaces is easy:

RegEx

[\.,\s]

But ... you will have to work out rules for you second requirement fairly carefully - when does a space get removed? Is it "not after a word of sufficient length"? Or "not between two words of sufficient length"? What about "I am a human"? Should that remain as it is, or have some or all spaces removed? What about "I, a human ..."?

I suspect that you are going to stress Regexes too far to get maintainable code and meaningful results, and that you will need to define your problem to yourself a load better before you even try to sort this - with or without a Regex!