How to define regular expression patterns like {min,max} repeats in SSMS or VS "Find and Replace" ?

Question

I knew that we have something like this in regular expression syntax world.

*The syntax is {min,max}, where min is a positive integer number indicating the minimum number of matches, and max is an integer equal to or greater than min indicating the maximum number of matches.

So {0,} is the same as , and {1,} is the same as +

http://www.regular-expressions.info/repeat.html

---

but how can i use it in SQL Server Management Studio or Visual Studio "Find and Replace" Window. I only find related Microsoft syntax in MSDN. Like:

[0-9]^4 matches any 4-digit sequence.

Answer 1

The Visual Studio regex implementation is a fairly nonstandard one to say the least, and it doesn't have this feature. You can only spell it out:

* or @: Match zero or more of the preceding expression

+ or #: Match one or more of the preceding expression

^n: Match exactly n repetitions of the preceding expression

So for A{2,4} you'd have to use A^4|A^3|A^2 (see polygenelubricant's comment for an explanation why you need to do it in descending order).