View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Help with a Regex Pattern

On Sun, 29 Apr 2007 10:56:01 -0700, Joel
wrote:

I though the ? represent any one character.


That is incorrect. At least with VBScript flavor of Regular Expressions, as
used in my expression, it indicates that the preceding (enclosed in parentheses
(is optional). To be more precise, it matches the preceding character or
subexpression zero or one time, so it is equivalent to {0,1}

It can also indicate a non-greedy quantifier.
--ron