On Sat, 2006-12-23 at 08:23 +0000, Harold Fuchs wrote: > On Friday, December 22, 2006 5:45 PM [GMT+1=CET], Barrie Backhurst > <[EMAIL PROTECTED]> wrote: > > > On Fri, 2006-12-22 at 11:41 +0000, Harold Fuchs wrote: > >> On Friday, December 22, 2006 10:39 AM [GMT+1=CET], Pradeep Srinivas > >> <[EMAIL PROTECTED]> wrote: > >> > >>> On Friday 22 December 2006 15:12, Harold Fuchs wrote (regarding Re: > >>> [users] Re: Finding Several Numbers in Calc (was Re: [users] > >>> [moderated] YOU MUST GIVE A SUMMARY HERE)): > >>>> On Friday, December 22, 2006 5:28 AM [GMT+1=CET], Pradeep Srinivas > >>>> > >>>> <[EMAIL PROTECTED]> wrote: > >>>>> On Thursday 21 December 2006 20:56, Larry wrote (regarding Re: > >>>>> [users] Re: Finding Several Numbers in Calc (was Re: [users] > >>>>> > >>>>> [moderated] YOU MUST GIVE A SUMMARY HERE)): > >>>>>> Sorry to keep 'pestering' you Harold, you seem to be the only > >>>>>> person who has a grasp of my concern. I am using version 2.0.4 > >>>>>> of OO on Windows XP. I guess the best way to explain my problem > >>>>>> is to show you my spreadsheet. > >>>>>> > >>>>>> 579374448 > >>>>>> 2416253949 > >>>>>> 81524303132 > >>>>>> 1713273237 > >>>>>> > >>>>>> > >>>>>> That example is just 4 rows of approximately 50. When I enter > >>>>>> (try) any of your suggestions into the "find", the result is a > >>>>>> hi-lite of only one number Say for example I need to find the > >>>>>> numbers 8, 15, 16, 25, 32 and 49. I can search for 8, then search > >>>>>> for 15, then 16, etc., one at a time which is time consuming, I > >>>>>> would like "find" to hi-lite all six numbers all at once, like > >>>>>> this: 579374448 > >>>>>> 2416253949 > >>>>>> 81524303132 > >>>>>> 1713273237 > >>>>>> > >>>>>> > >>>>>> Oh and yes, the numbers are all whole numbers, they are not > >>>>>> formulas or the results of formulas. > >>>>>> Thanks again and I really do appreciate you assistance > >>>>>> > >>>>>> Larry, > >>>>>> Brampton, Ontario, Canada > >>>>> > >>>>> Hi Larry, > >>>>> > >>>>> Let me take a stab at this problem.... If I understand you, you > >>>>> have the numbers as mentioned above in ONE column, and you want > >>>>> to search for (say), 949 and (say) 3132. There could be other > >>>>> criteria for the search as well, but the logic is the same, and > >>>>> extensible. > >>>>> > >>>>> * Open the Find and Replace box (edit > Find and replace, or > >>>>> Cntl-F) > >>>>> * Click the "more options" to drop down the more options > >>>>> * Click the check box next to Regular Expressions > >>>>> * In the combo box for "Search In", choose "Values" > >>>>> * In the Search Direction, choose "Columns" radio button > >>>>> * Right at the top of the dialog, type in, WITHOUT the double > >>>>> quotes, the following: "949|3132". > >>>>> * Hit "find all" > >>>>> > >>>>> On the spreadsheet, you will see the two cells that contain these > >>>>> values highlighted (namely 2416253949 and 81524303132) > >>>>> For each additional "search pattern" you require, add it to the > >>>>> existing search, with a "|" preceding it. > >>>>> > >>>>> This works even for values calculated by formulation (this is in > >>>>> answer to another poster asking this question, as an offshoot of > >>>>> your original qustion), but then, you need to choose "Values" in > >>>>> the "Search In" combo box. > >>>>> > >>>>> Now, if you want to search for a digit (or more than one digit) > >>>>> ONLY at the start of the number, precede the digit (or the digit > >>>>> sequence) with a "^" (without the quotes, of course), and if you > >>>>> want to search for something similar ONLY at the end of the > >>>>> number, put a "$" at the end of the search string. There is > >>>>> more, and if you require more info, email me off list. > >>>>> > >>>>> Hope that this helps - do note I am on OOo 2.0.2 on FC 5, build > >>>>> 2.6.18-1.2254, and your milage may vary on other versions of OOo > >>>>> on other platforms. > >>>>> > >>>>> Pradeep Srinivas > >>>>> Bangalore, India. > >>>> > >>>> Pradeep, > >>>> > >>>> 1. He wants to find exact values. So finding 949 as part of > >>>> 2416253949 does not solve the problem. Hence my attempt to use ^ > >>>> and $ to surround the value. > >>>> > >>>> 2. The data you are taking his example from has been mangled by the > >>>> mail system converting from an HTML table to raw text. The table as > >>>> he sent it has 4 rows of 6 1- or 2-digit numbers. Your example > >>>> 2416253949 was actually 6 values: 2 4 16 25 39 49 > >>>> > >>>> Regards, Harold > >>> > >>> Harold, > >>> > >>> Thank you for pointing out the mangled table - I thought the entire > >>> sequence of digits was one large number. However, I did break the > >>> digits into smaller sequences (arbitrary, I confess, of 1- and > >>> 2-digits), and tried to work the logic I had given above - it > >>> failed. > >>> > >>> So came up with (arbitrary) sequences to search for - say, 25 and 9 > >>> etc. What I could find was that you cannot give a > >>> "^number$|^number$" - you needed to give a range like > >>> "^[1-46-9].*5$|^[1-9]$". That worked. > >>> > >>> So, unless we (well, I) know EXACTLY what the OP is searching for, > >>> and what is failing (sorry, I am more than averagly dense, and may > >>> have missed the point), I do not think we can reach a solution. > >>> Perhaps we should take this thread off post ? No offense meant to > >>> the posters, of course. > >>> > >>> Regards, Pradeep > >> Pradeep, > >> > >> I think he wants a generic way of searching his table and > >> highlighting all of a series of numbers chosen according to some > >> criteria that vary from spreadsheet to spreadsheet. So, one day he > >> may be searching for 1, 3 56, 67.8 and 45.3 but the next day > >> some/all of the numbers will/may be different. I think the criteria > >> are probably derived from the data or, possibly, his boss ;-) > >> > >> It's really a shame that the ^...$ thing doesn't seem to work. > > > > I think this should work(using Larry's example), excluding the quotes. > > > > "^(8)?(15)?(16)?(25)?(32)?(49)?" > > > > Barrie > It does work but it also finds 250 (25 on the left), 132 (32 on the > right) and 271699 (16 in the middle). > Regards, Harold >
Oops! Taking a different approach the following seems to work using whole numbers(and therefore should solve Larry's problem), but if decimals(e.g 3.8,8.3,26.8,32.2) are introduced into the search range it fails and I can't work out why at the moment. "\<(8)\>|\<(15)\>|\<(16)\>|\<(25)\>|\<(32)\>|\<(49)\>" Barrie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
