Questions tagged [range]
A range is an extent of values between its lower and upper bound. It can refer to a DOM Range, the Ruby Range class, the Python range function, Perl 5's `..` operator, Perl 6's Range Class, or PostgreSQL's range types.
range
10,685
questions
0
votes
0
answers
17
views
C++ - Questions about bit shift operators (<< and >>)
Consider the below code:
std::string g_CharTable = "stjkloptrew23456mncv891TZUIOPAS";
std::uint32_t value = 123456789
std::string hash;
for (std::size_t i = 0; i < 5; ++i)
{
...
0
votes
1
answer
26
views
How to pull a range of values and add it to a date depending on it meeting a certain condition
Am trying to automatically sum up Dates based on a certain size of a feature and it's estimate and I am wondering if we can do this without if statements?
So If I enter a new feature of a certain size ...
2
votes
1
answer
41
views
copy a range from one worksheet to another without blank rows
I have a range named in a worksheet that is five columns wide and approximately 220 rows long. The rows within that range are primarily formulas that pull data from other locations and concatenate or ...
-1
votes
0
answers
19
views
Hive sql repeating records with amount differing only by +-5%?
How to delete repeating records with amount differing only by 5%? by amount in the range amout-5% to amount+5%?
Here is an example table on hive
[# a.uk b.uk AMOUNT START_DATE FINISHED_DATE source
1 ...
-5
votes
2
answers
94
views
How to decrease the range of the for loop in python?
In this question I wanted to find min(m+k) such that mCk =n, I wrote a code to brute force for my sequence, The problem was that my code isn't fast enough so I want to decrease the length of the for ...
0
votes
0
answers
14
views
Where is the documentation on the extra attribute on a Range? [duplicate]
I just found out about C# ranges, thanks to VSCode Quick Fixes, which looks very nice (especially coming from Python). The one thing that I cannot find any documentation on, though, is the supplying ...
0
votes
1
answer
37
views
Snowflake SQL. Select column value if 1st 5 characters are numeric and within a Numeric Range
I have a column named ProcedureCode VARCHAR(16777216) in a Table named ProcedureCode.
It has values like '12345,46H', 'A4715,12W', '98765', '99200' etc.
From that Table, I need to pull only rows where ...
0
votes
0
answers
27
views
Representing an 8-digit hexadecimal as a long [duplicate]
I am writing a Java program that performs bitwise operations on bites in a data stream.
I have been given test values in the form of 8-digit hexadecimal strings, which I have converted to base 10 and ...
3
votes
3
answers
69
views
Explanation about awk matching a pattern between a range of lines
I have an Awk one-liner that, while I understand what is being accomplished at a high level, I don't fully understand how Awk is accomplishing the task I give it. I'm asking Awk to give me a range of ...
-1
votes
2
answers
110
views
Fastest way to generate numbers up to a range in Python
I want to create a list of numbers that contains three consecutive 1s in its binary representation. To do this, I make set of number up to 2**n, and subtract it with a set of numbers that contains NO ...
0
votes
1
answer
41
views
Python xlwings slow Execution when scanning Excel Sheet
I'm a beginner at Python.
This code is for scanning Excel cells by range using xlwings however the process is very slow.
I strictly need to use xlwings since it can retain my images and shapes unlike ...
0
votes
0
answers
24
views
Adding multiple range in 1 seclection
I need to add 2 range in 1 selection
Here is my code trying to add a new range to a current selection
<p id="p">Select me: <i>italic</i> and <b>bold</b></p&...
0
votes
1
answer
34
views
VBA using a variable to select a column
I am extremely new to coding so forgive me if this is going to be a super simple task.
I am trying to trim any extra spaces from the beginning and end of a column called ID.
I already have a global ...
0
votes
1
answer
34
views
Incorrect OR evaluation of cell range
Edited
I have a custom formula in conditional fange that fails to do the expected.
The condition depends on 3 factors with AND and OR spanning on a range from line 2 to 726.
=and(X2>1000,OR(AC2=&...
0
votes
3
answers
78
views
How to copy a range to several worksheets by using a list of worksheets to copy to
VBA novice here. I have a complex spreadsheet but I’ll simplify it for my question. Let’s say I have a workbook with 20 worksheets. Each worksheet has a three-letter name such as ABC. In the first ...