Re: [libreoffice-users] Regular expressions

On Thu, 8 Jul 2021 22:38:49 +0100
David Lynch <dlynch1319ng@gmail.com> wrote:

> The documentation 
> <file:///C:/Program%20Files/LibreOffice/help/en-GB/text/scalc/01/04060181.html?DbPAR=CALC#bm_id3164897>
> for COUNTIF gives the following examples, among others:
>
> =COUNTIF(A1:A10;">=2006")  
> =COUNTIF(A1:A10;"<"&B1)
> =COUNTIF(A1:A10;C2)
> =COUNTIF(A1:A10;"<0")
>   and these do indeed work.
>
>   However the list of regular expressions linked from the COUNTIF
> page
> <file:///C:/Program%20Files/LibreOffice/help/en-GB/text/shared/01/02100001.html?&DbPAR=CALC&System=WIN>
> does not include the use of > and < as operators.
>
> Neither does the "full list of supported metacharacters and syntax" 
> <https://unicode-org.github.io/icu/userguide/strings/regexp.html>
> linked from the help page in the previous paragraph.
>
> Neither does the page
> <http://userguide.icu-project.org/strings/regexp> linked from the
> REGEX help page
> <file:///C:/Program%20Files/LibreOffice/help/en-GB/text/scalc/01/func_regex.html?DbPAR=CALC#bm_id831542233029549>
>
> Please, is there anywhere that tells me what regular expressions are 
> supported?
>
> David Lynch
>
> Version: 7.1.4.2 (x64) / LibreOffice Community
> Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
> CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
> VCL: win
> Locale: en-GB (en_GB); UI: en-GB
> Calc: threaded

I don't believe that '>'and '<' used as operators are regular
expressions. They are parts of more general 'criteria', which the
documentation
<https://wiki.documentfoundation.org/Documentation/Calc_Functions/COUNTIF>
implies are 'wild cards'. But searching the documentation doesn't reveal
any definition or even explanation of what a wild card is :(

So I think the answer to your question is that the definition of
regexes supported is indeed
<https://unicode-org.github.io/icu/userguide/strings/regexp.html> but
that the particular criterion you are interested in is not a regex and
thus not documented there. Perhaps somebody else knows where such
criteria ARE documented?

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy