Extend FIND and SEARCH to look for the Nth instance of a subtext in a longer text
FIND and SEARCH currently will only find the first instance of a required text within a longer text and they always search from the beginning or to the right of a specified position. These functions would be much more useful if one could for example look for the third comma in a text or (most easily instituted by using negative counts) for the, say, third comma from the end of the text. So instance -1 of "a" in "banana" would yield a position of 6, the last "a" in the word, and instance 2 of "n" would yield 5, the second "n". And that would be the same result as searching for the -1st "n", i.e., the last "n".
This should be easy to implement and require only a moderate change to the syntax of the functions.
There is a similar request already posted under "Extract groups of numbers or characters from TEXT", but it is not quite the same and the other suggestion is considerably more complicated.
Kenneth Barber commented