On Thursday 04 January 2007 15:03, Harold Fuchs wrote (regarding Re: [users] Finding Several Numbers in Calc): > On Thursday, January 04, 2007 3:00 AM [GMT+1=CET], Pradeep Srinivas > > <[EMAIL PROTECTED]> wrote: > > On Thursday 04 January 2007 05:49, Harold Fuchs wrote (regarding > > > > [users] Finding Several Numbers in Calc): > >> Some time ago a long discussion took place with the above subject. I > >> entered a bug report. Yesterday I had a response: > >> > >> Use the regular expression "^(1|2|3)$" (without the quotes) to find > >> 1 or 2 or 3. This seems to work. > >> > >> Decimal values also seem to work, so "^(1.5|2.7|3.6)$" finds and > >> highlights all cells containing 1.5 or 2.7 or 3.6 > >> > >> A very nice belated Christmas present. > > > > Harold, > > > > Subsequent to the discussion, and off the list, I also found out that > > the following would work as well: > > \<5|\<7|9\> > > This would find a 5 or a 7 at the start of the line, but not at the > > end (or anywhere else), or a 9 at the end of the line, but not > > anywhere else. > > Pradeep, > > The nice thing about the solution I quoted from the OO bug fixer is that > it finds *exact* values. So my integer example will not find 21 or 12 > but only 1 or 2, and my decimal example will not find 31.5 or 1.57 but > only 1.5. That's because they include both ^ and $. > > Regards, Harold
Harold, Agreed, yes, that is right. -- Pradeep Srinivas Bangalore, India --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
