VBScript - Regular Expression replace spaces

Question

I have a situation where using VBScript I need to check for the presence of multiple spaces. I want to check for the presence of 2 or more consecutive spaces, so \s+ doesnt work for my needs.

Does anyone know how I can accomplish this using VBScript regular expressions.

\s+ doesn't work because it matches one or more spaces. What about just using \s\s+? — Carl Norum
– Carl Norum, Commented Oct 28, 2010 at 22:44

Guffa · Accepted Answer · 2010-10-28 23:01:03Z

4

Use brackets to specify how many repetitions to match. This matches two or more whitespace characters:

\s{2,}

If you want to match only space characters, just use a space instead of \s, or the character code:

\x20{2,}

edited Oct 28, 2010 at 23:01

answered Oct 28, 2010 at 22:47

Guffa

703k111 gold badges760 silver badges1k bronze badges

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

1 Comment

Robusto Over a year ago

+1 because we got the same answer at the same time, but I got the check.

Robusto · Accepted Answer · 2010-10-28 22:46:54Z

2

This ought to do the trick:

\s{2,}

answered Oct 28, 2010 at 22:46

Robusto

32k8 gold badges59 silver badges79 bronze badges

2 Comments

Mick Over a year ago

Thanks for your answers.This seems to also replace new line characters.

Robusto Over a year ago

try [ ]{2,} then. You don't really need the brackets around the space, but it's hard to show the space in a comment here. Or do it as Guffa shows, using \x20 (representing the ASCII value of the space character. Either way, show your appreciation by upvoting us and/or giving someone a checkmark if our answers helped you.

Collectives™ on Stack Overflow

VBScript - Regular Expression replace spaces

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related