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]
