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