List:
Using Calc, from OOo 2.2, on Linux
I would want to know if there is any way that the SEARCH (or FIND or any other
equivalent function) would return ZERO if the searched item was not found.
For instance, if A1 contained "Server", then,
=SEARCH("Server"; A1) would return 1.
However, if A1 contained "JUNK", then,
=SEARCH("Server"; A1) returns "#VALUE!". I would rather that this returns "0"
(or even "-1"), instead of a "#VALUE!".
Am I doing something fundamentally wrong ? If not, is there any function that
would
a. return 0 if a search item was not found
or
b. take the #VALUE and convert it to something that a logical function (like
IF() ) can use ?
or
c. is there a function that behaves like the "regular expression match"
operator in awk (the "~" operator, as in "$1 ~ Server )
--
Pradeep Srinivas
Bangalore, India
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
