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 to do is have a column O that has a 1 if ANY TEXT in column N is equal to "regression" so all three of the above strings would show a 1. Clear? Hope so, best regards, Joel On Fri, Feb 8, 2013 at 8:06 AM, Johnny Rosenberg <[email protected]>wrote: > 2013/2/8 Brian Barker <[email protected]>: > > 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 fallen > > into the error that is not at all uncommon amongst enquirers. You have > > shown us a formula which you tell us does not work. You have not told us > > what you were hoping it would do for you, leaving us to guess from the > > formula itself. But the one thing we can be absolutely sure of - we have > > your assurance for this - is that this formula does not define what you > are > > trying to do, since it does not succeed. > > > > In any case, I don't know what regular expression you think you have > > supplied here: the asterisk is used to match zero or more of the > character > > preceding it. There is no character before your first asterisk; as > regards > > the second, are you expecting a match for *regressio, along with > > *regression, *regressionn, *regressionnn, and so on? > > > > The IF() function is a bit of a red herring. The essence of your > formula is > > the logical expression N200="*regression*". This has a logical result > > (which, incidentally, is identical to the result of your IF). But there > is > > no facility to invoke regular expressions in the logical "=" operator: it > > will give the answer TRUE (or 1) if and only if the two operands are > equal. > > So you should get TRUE or 1 if N200 is exactly "*regression*" and FALSE > or 0 > > otherwise. > > > > There are a number of functions which allow regular expressions (see the > > help text), but "=" is not one of them. > > > > I trust this helps. > > > > Brian Barker > > > Very funny indeed. > The rest of us, who hopefully are thinking creatures, realise that he > accidently gave an example of ”wild cards” while talking about regular > expressions. Since he was talking about regular expressions all the > time, I think most people would assume that that is what he meant, and > that the example probably was a typo or that he don't know the > difference. Yet… > > Anyway, … never mind, I don't have time for this. > > > > > > > -- > > For unsubscribe instructions e-mail to: > [email protected] > > 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: [email protected] > 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 > -- *Joel Madero* LibreOffice QA Volunteer [email protected] -- For unsubscribe instructions e-mail to: [email protected] 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
