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 Srinivas Bangalore, India --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
