This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
This is an important distinction between Ben’s formula and mine. Mine only removes digits at the start of the string. Ben’s removes all digits everywhere in the string.
Note that this can be problematic. What if there are two or more spaces next to each other that were in the original string that did not have digits between them? This formula will remove those additional spaces as well.
There are a few other options. Instead of using '\s{2,}' you could also use ' +' to find one or more spaces and replace them with a single space. This would have the same effect. It depends on what you find easier to read and how much work you want the computer to use.
However, another option would be when searching for digits to search for one or more digits and zero or more trailing spaces in the initial REGEX_REPLACE: '\d+ *. This would leave any consecutive spaces that were supposed to be there unaffected.
I agree. A regex tester is essential to learning regex. However, I find that different regex testers have different helps, so if one doesn’t work for you, try a different website.
There are many ways to do things in REGEX. Testing with a wide variety of inputs is essential to getting the result you want.
