Hello list members,

does Calc permit regular expressions in the FIND() function?

I thought YES, but:
=IF(ISERR(FIND("[^O]ANA";B2));0;FIND("[^O]ANA";B2))

did NOT result in any matches. I am using OOo-dev3 m29. Enable regular expressions in cells is activated.

Did I miss something? I was pretty sure it will work.

Sincerely,

Leonard


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to