On Thursday 04 January 2007 23:31, Galen wrote (regarding [users] Problem with
regular expression in FIND() worksheet function):
> Suppose I enter the following expression into a cell on a Calc worksheet,
> say, cell A1 for convenience:
>
> =FIND("[a-c]","abc123")
>
> Cell A1 will now display "1" as you'd expect.
>
> Now I change this to
>
> =FIND("[^a-c]","abc123")
>
> I would expect cell A1 to now display "4" as that's where the first
> character that isn't one of a,b, or c is located.
>
> Instead I see: "!VALUE#"
>
> This happens with every [...] pattern that I've tried. (Of course, I
> haven't had time to try them all yet. :-D )
>
> I'm using OpenOffice V2.0.1 with OS X V10.3.9. Is this broken, or am I
> doing something wrong?
Hi Galen,
I agree with Joe (Joe Smith <[EMAIL PROTECTED]>) when he says that the FIND
function returns #VALUE on entering the parameters you have used. It looks
like the FIND function can not understand regular expressions in the "find
text" portion of the function (i.e., the first argument to the function) and
therefore, cannot interpret the "[a-c]" as "a", "b", or "c".
I also tried out the SEARCH function, and it works the way Joe said it worked.
--
Pradeep Srinivas
+91 994 002 2692
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
