To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=66590
User discoleo changed the following:
What |Old value |New value
================================================================================
Summary|Calc: String Functions: FI|Calc: String Functions: Ex
|ND() |tended FIND() Function
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Aug 12 21:17:16 +0000
2008 -------
Searching on the MS forums I saw some other requests that could well be handled
by this extended function.
FINDEX()
Function Syntax: FINDEX(string, string, START, END)
Initially, when I wrote the code for the FindEx() function, I did NOT interpret
specifically a negative END position, BUT returned 0 IF START > END.
I did played with the idea to interpret negative values as pointing to the _end_
of the original string, though the code would have become to complex and I
abandoned the idea. The requests to search the end of the string (and even a
reverse search) did pop up on the MS forums, so I think it is time to get into
such an extended FINDEX() function, too.
The idea:
- IF (START < 0) => begin to search at string position:
strlen() + START /* REMEMBER: START is negative */
- IF (END < 0) => end search at string position:
strlen() + END /* REMEMBER: END is negative */
So, it would be possible to specify relative positions from the beginnineg or
from the end of the original string.
This function would not cover a reverse-search, however, one could similarly
define an RSearchEx() function.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
