Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


Apologies if this appears twice; im not sure if there was a problem with sending...

Hello,
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?

Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.