regular expression for calc

classic Classic list List threaded Threaded
1 message Options
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view

regular expression for calc

I have a column each row of which contains a sequence of one or more codes separated by a space. In case it will make a difference each code consists of a letter (ooccasionally 2 letters) followed by a number of up to 3 digits (and occasionally ends with a letter) eg X1 Aa12 D7a etc.

I  want to obtain a regular expression for COUNTIF that will enable me to find out how many times a particular code, contained in another cell, occurs in the column. I was thinking that \b to detect the word boundaries should help but i cant quite get it to work; im not sure if this is because it is assuming a word boundary between the letter and the number or if it is simply my incompetence as usual.

Does anyone have an idea what may be the best way to achieve this?


To unsubscribe e-mail to: [hidden email]
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted