Re: [libreoffice-users] regular expression for calc

Did the OP get this working. I have it working with =COUNTIF(SEARCH("\b"&$G$37&"\b",E37:E39),">1") $G$37 contains the search term with word boundaries. E37:E39 is the range I am searching. Enter into the cell where you want the answer =COUNTIF(SEARCH("\b"&$G$37&"\b",E37:E39),">1") and press

Re: [libreoffice-users] regular expression for calc

Hi Regina, Thank you, yes, that's cracked it. (*so* many pitfalls for the unwary!) Best Gary On Sun, 12/3/17, Regina Henschel <rb.hensc...@t-online.de> wrote: Subject: Re: [libreoffice-users] regular expression for calc To:

Re: [libreoffice-users] regular expression for calc

If the code you are looking for only occurs once per cell you could use find() or search() against each cells to determine if the code is present then countif() the results where greater than zero. On Sun, Mar 12, 2017 at 1:50 PM, Regina Henschel wrote: > Hi Gary, > >

Re: [libreoffice-users] regular expression for calc

Hi Gary, find the option "Search criteria = and <> must apply to whole cells" in Tools > Options > Calc > Calculate. Try it with disabled option. Kind regards Regina Gary Collins schrieb: Hi Brian I wish i could say it did help but unfortunately not. It works with the whole cell contents

Re: [libreoffice-users] regular expression for calc

and im using 64bit windows 7. G. On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] regular expression for calc To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 15:45 11/03/2017 +, Gary Collins wrote: >

Re: [libreoffice-users] regular expression for calc

At 15:45 11/03/2017 +, Gary Collins wrote: 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 (occasionally 2 letters) followed by a number of up to 3 digits (and occasionally