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

2013-02-08 Thread Johnny Rosenberg
much any more, since a better answer already arrived on this list: -- Forwarded message -- From: Johnny Rosenberg Date: 2013/2/8 Subject: Re: [libreoffice-users] IF w/ Regular Expression To: Joel Madero 2013/2/7 Joel Madero : > Hi All, > > I have enabled regular

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

2013-02-08 Thread Joel Madero
> For what it's worth, my "funny" reply was meant quite seriously: I wasn't > being sarcastic. > > Yes: quite clear this time. Try: > =NOT(ISERROR(FIND("regression"**;Nn))) > (Regular expressions not involved.) This will populate your column with > TRUE and FALSE; if you prefer, you can change th

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

2013-02-08 Thread Brian Barker
At 08:45 08/02/2013 -0800, Joel Madero wrote: On Fri, Feb 8, 2013 at 8:06 AM, Johnny Rosenberg wrote: 2013/2/8 Brian Barker: At 14:05 07/02/2013 -0800, Joel Madero wrote: I have enabled regular expressions in LibreOffice settings but still am unable to get this one to work. Here is my line:

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

2013-02-08 Thread Joel Madero
I actually went to bed thinking "crap, that email wasn't very clear " lol. My apologies indeed, I should know better! So I have a column N that has keywords, some of them are blank, some of them have items such as "regression" or "regression, bibisect" or "bibisect, regression" etc... What I want

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

2013-02-08 Thread Johnny Rosenberg
2013/2/8 Brian Barker : > At 14:05 07/02/2013 -0800, Joel Madero wrote: >> >> 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. > > > What you are missing, I thi

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

2013-02-08 Thread Brian Barker
At 14:05 07/02/2013 -0800, Joel Madero wrote: 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. What you are missing, I think, is defining your problem! You have fal

[libreoffice-users] IF w/ Regular Expression

2013-02-07 Thread Joel Madero
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! -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- For unsubscribe instructions e-ma