-Queue- Posted August 13, 2004 Posted August 13, 2004 In response to a thread on another forum, here is a Custom Function that will return the number of consecutive occurrences of the specified character or character type (digit/alpha) with the specified frequency (consecutively) for the given text. For example, if the text is AABBABBBA1, the character is A, and the frequency is 2, then the result will be 1. If the character is B, the result will be 2. If the character is 'digit' and 1 is the frequency, 1 is the result; if 'alpha', then 9. Note that this function is case-insensitive and will not work for compound characters, e.g. 'ab', '49'. RegExp.zip
Recommended Posts
This topic is 7474 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now