Fwd: [libreoffice-users] IF w/ Regular Expression

Aah, now I see, I did the same mistake I always do on this list, I
emailed the OP personally. I do that a lot since this list changed its
behaviour, sorry. I never learn, as it seems…
Just in case anyone is curious, here is what I wrote this morning
(local time), even though it doesn't mean much any more, since a
better answer already arrived on this list:

---------- Forwarded message ----------
From: Johnny Rosenberg <gurus.knugum@gmail.com>
Date: 2013/2/8
Subject: Re: [libreoffice-users] IF w/ Regular Expression
To: Joel Madero <jmadero.dev@gmail.com>


2013/2/7 Joel Madero <jmadero.dev@gmail.com>:
> Hi All,
>
> I have enabled regular expressions in LibreOffice settings but still am
> unable to get this one to work. Here is my line:
>
> IF(N200="*regression*",1,0)
>
> Not sure what I'm missing. Thanks!



As far as I know, IF doesn't support regular expressions.

In your case, this will probably work:
IF(ISNA(FIND("regression";N200));0;1)

I know, very clumsy and probably slow too.


Johnny Rosenberg
> --
> *Joel Madero*
> LibreOffice QA Volunteer
> jmadero.dev@gmail.com
>
> --
> For unsubscribe instructions e-mail to: users+help@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

-- 
For unsubscribe instructions e-mail to: users+help@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