On 09/12/2007 06:45, Henry Ballard wrote:
I am using openoffice 2.3 - just downloaded it and installed it this week.
In calc, I was trying to search for something more than a simple string - looking at the documentation of the regular expressions
"supported", I found that searching for "M" was fine but "[M]" is not found - it says #value (???).
Then I tried =SEARCH("M|I";"Misty")
and that doesn't work either. Then I tried
=SEARCH("[:alnum:]";"Misty")
with no different luck. So far, I'm wondering if any regular expressions work. Or maybe there's some trick. Or the documentation is misleading.
Any insights?
Thanks,
Henry
Have you actually turned on the Regular Expression option? In the Search
& Replace pane click More Options and then select Regular Expressions.
If that still fails, come back here with more information about exactly
what you are doing.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
