Mark Kingsley
New Member
- Joined
- Nov 4, 2002
- Messages
- 2
This is a 2 part question.
1) Is there a formula that can be used to find the "nth" occurrence of a character in a string?
For example, how could you determine that the 3rd occurrence of "s" in the word "suggestions" is the 11th character?
2) Is there a function/formula that would return "3" for the number of times "s" appears in "suggestions"?
1) Is there a formula that can be used to find the "nth" occurrence of a character in a string?
For example, how could you determine that the 3rd occurrence of "s" in the word "suggestions" is the 11th character?
2) Is there a function/formula that would return "3" for the number of times "s" appears in "suggestions"?