Looks to me like your RE doesn't have any provisions for alphabetic stuff to come between a second comma and a right square bracket.
Donald. -------------- Original message ---------------------- From: Mark Phillips <[EMAIL PROTECTED]> > I am using Dcount() to count the occurrences of some strings in a spreadsheet > in OpenOffice Calc 2.0.3. I am using a regular expression to find the string > I want. My regular expression is > > \[['a-zA-Z', ]*'Board Member'(, )?['a-zA-Z']*(, )?\]|Board Member > > It works for all of these test cases: > ['Volunteer', 'Board Member', 'Coach'] > Board Member > ['Volunteer', 'Manager', 'Board Member'] > > but not this one: > ['Board Member', 'Volunteer', 'Coach'] > > I had thought this part of the regular expression ['a-zA-Z', ]* would take > care of this case with the "zero" part of the definition of the "*". But it > doesn't. Do I need to add another "or" term for this case, or is there a way > to modify my regular expression to handle this case. > > BTW, I tried using [:alpha:] instead of [a-zA-Z], and dcount() did not find > any matches. Is [:alpha:] not working - it is listed in the documentation as > a valid regular expression. > > Thanks! > -- > Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
