Given an array of integers, what is the simplest way to iterate over it and figure out all the ranges it covers? for example, for an array such as: $numbers = array(1,3,4,5,6,8,11,12,14,15,16); The ranges would be: 1,3-6,8,11-12,14-16 ...
Why or why not? ...
I have a table which contains my server status create table ServerStatus ( ServerId int, StartTime datetime, Seconds int, [State] char(8) ) I would like a query that given a start and end date will summarize the time the server spends in each state during that time. I would also like the query to return the amount o...
Hi, if I have a range of say 000080-0007FF and I want to see if a char containing hex is within that range, how can I do this? Thanks a lot. Example char t = 0xd790; if (t is within range of 000080-0007FF) // true Thanks ...
Hi, let's say I have a excel spread sheet like below: col1 col2 ------------ dog1 dog dog2 dog dog3 dog dog4 dog cat1 cat cat2 cat cat3 cat I want to return a range of cells (dog1,dog2,dog3,dog4) or (cat1,cat2,cat3) based on either "dog" or "cat" I know I can do a loop to check one by one, but is there any other me...
I'm looking for a macro which can be run to select a consistent range of cells so that I can easily copy them to another spreadsheet. The range would be F3:BJ3. Thanks for your help. nlh ...
Hi all, I recently learnt that oracle has a feature which was pretty useful to me - as the designer/implementator didn't care much about data history - I can query the historical state of a record if it's available yet in the oracle cache, like this: select * from ( select * from sometable where some_condition ) as of t...
Hello, I am trying to generate a random number with Java, but random in a specific range. For example, my range is 5-10, meaning that 5 is the smallest possible value the random number can take, and 10 is the biggest. Any other number in between these numbers is possible to be a value, too. In Java, there is a function random() in the...
Hello.. MySQL column > sdate, edate ( its 2 column). sdate is start date for project starting and edate is end date for project ending. so i need to make search between them.. <strong>Search</strong><br /> <form method="post" action="search.php"> Start Report Date : <input type="text" name="sdate" /> End Report Date : <input type...
The code below is checking performance of three different ways to do same solution. public static void Main(string[] args) { // for loop { Stopwatch sw = Stopwatch.StartNew(); int accumulator = 0; for (int i = 1; i <= 100000000; ++i) { accumulator +...
Suppose I have a std::vector (let's call it myVec) of size N. What's the simplest way to construct a new vector consisting of a copy of elements X through Y, where 0 <= X <= Y <= N-1? For example, myVec [100000] through myVec [100999] in a vector of size 150000. If this cannot be done efficiently with a vector, is there another STL da...
Hi there, I'm having some trouble with a large spreadsheet of mine. I bring in a lot of raw data into a data sheet, and then do a number of lookups across the data. Using built in functions I've come up with =IF(ISNA(INDEX(Data!$L$7:$L$1100,MATCH(Data!$I$2&$B$199&$B29&Data!$J$5,Data!$K$7:$K$1100&Data!$J$7:$J$1100&Data!$I$7:$I$1100&Data!...
I need to generate a list of sequential numbers. I know Ruby you can do 1..10 or PHP you can do range(1, 10). Anything like that in .Net already, or do I have to write it? Thanks. ...
Using Excel Interop (.NET) how can we set programmatically two different Excel formulas for every other column. For instance, Range r = _sheet.get_Range(_sheet.Cells[1, 1], _sheet.Cells[I, J]) r.Formula = "=something1" will do it for every cell. But within J columns every other column has to have formula "=something2". The size ...
Imagine a scenario where, using xml, the user is able to specify ranges in a flexible manner, using any combination of "gte", "gt", "lte", "lt" or "eq". Here are some examples <rangeElement gte="0" lt="5" ... /> <rangeElement gt="3" lte="7" ... /> <rangeElement eq="5" ... /> <rangeElement gt="10.5" ... /> Now what I need is two class...
Is there a way to step between 0 and 1 by 0.1? I thought I could do it like the following but it failed: for i in range(0, 1, 0.1): print i Instead, it says that the step argument cannot be zero, which it's not. Thanks. ...
I want to find a string in a word document and delete everything after it. What is the best way to do this without using the selection object? Thanks ...
The default [1..5] gives this [1,2,3,4,5] and can also be done with the range function. Is it possible to change the step size between the points, so that I could get something like the following instead? [1,1.5,2,2.5,3,3.5,4,4.5,5] ...
Given a set of random numeric values in a database, how do I generate a limited list of ranges where each range contains at least one value? The ranges should not overlap and ideally have a similar amount of values in them. Ideally their boundaries should also be multiples of 10, 100, 1000 etc... For example: Values: 100,150,180,300,40...
Hey, I need to build a full "number range" set given a series of numbers. I start with a list such as : ID START * 0 a 4 b 70 c 700 d 701 e 85 where "def" is the default range & should "fill-in" the gaps "overlaps" are value (70, 700, 701) in starting data And need the following result: ID ST...