## Add values < or eq to 1000

Add values < or eq to 1000
# 1
11-10-2009
Add values < or eq to 1000

make a list based on the first column key and corresponding value (2nd column-bold) in input1 search values that less than or equal to 1000 (2nd column-bold)in the input2 of the same key along with other columns.

input
input2
output
Thanx
 repinementer View Public Profile for repinementer Find all posts by repinementer
# 2
11-11-2009
Could you please explain it better !
 thegeek View Public Profile for thegeek Find all posts by thegeek
# 3
11-11-2009
Try this:

 Franklin52 View Public Profile for Franklin52 Find all posts by Franklin52
# 4
11-16-2009
Thanx

I sounded bit rude in the previous mail. My apologies. and Thanx for the code.
The code is giving me trouble when the size of the number increases.

example
input1
input2
 repinementer View Public Profile for repinementer Find all posts by repinementer
# 5
11-16-2009
Sorry, I don't think I understand your question. Can you clarify the question, maybe with more examples?
 Franklin52 View Public Profile for Franklin52 Find all posts by Franklin52
# 6
11-16-2009
The input1 contain keys in first column (x1,x2 and so on). second column contains values ranging from smaller to largest (1 to 10000000 and so on).Second input is also the same.

Logic is to find the values that are with in +/-1000 with corresponding to values in input1 (along with corresponding columns not shown below)
As you can see below the ist input value is 10000 (the values with in range of +/- 1000 i.e. +1000=11000 and -1000=9000 are in output others are not)

input1
input2
output
 repinementer View Public Profile for repinementer Find all posts by repinementer
# 7
11-16-2009
Quote:
Originally Posted by repinementer
As you can see below the ist input value is 10000 (the values with in range of +/- 1000 i.e. +1000=11000 and -1000=9000 are in output others are not)
Please be more specific, I've spend a lot of time trying to understand your question but without any luck (and I'm sure I'm not the only one at all).

What if the value of the 2nd column in the 1st file is 10, 18, 29, 100 or 1000?
 Franklin52 View Public Profile for Franklin52 Find all posts by Franklin52

Test Your Knowledge in Computers #288
Difficulty: Easy
In Linux, Logical Volume Manager (LVM) is a device mapper target that provides sound card I/O management for the Linux kernel.
True or False?

## Add values to file in 2 new columns

Columns 4 and 5 are X and Y coordinates, column 6 is the elevation I would like to add 2 new columns at the end of the file with values the distance between first(X)(Y) and last location (X)(Y), based in 2 rows the difference in elevation = (\$6-prev6) How to calculate the requested values...

## Add the values of the lines according to a condition

hi everybody :) I am a beginner in bash and I want to convert the result I have here I want it to be grouped by IP address so iwanna get for each ip adsress the addition of all bandwidth where ip is 100.1.1.15 in other words for 100.1.1.15 it groups me all the values whose ip address is...

## How to add one to each row values and keep it after the value in the column?

Dear Folks Hello I have a column of numbers, say: 26 79 68 I want to add one to each row value and get this desire column: 26 27 79 80 68 69

## Add 0 values to replace empty value

Hi Guys. Please can you help me to add 0 values. Starting in column 121 Imput file A 4175.0 8055.01211 75 1 -2172671 77 45 16 457626.4 2609265.1 131.3 1090 102 1 1T N/A124 15 0.8 1051670971100000 A 4175.0 8055.012 7 75 2 -5204072 78 43 25...

## Add values in 2 columns and subtract from third

Hi All, I have a file with thousands of lines in the following format, where Field1=First 8 characters Field2-9-16 characters Field3=17-26 characters I need to add Field 1 and Field2 and subtract the result from Field 3. Field3=Field3 - (Field1 + Field2) 0012.00 0010.00 0001576.53...

## 6. Shell Programming and Scripting

Hi, I have a file with 3 columns ABC 3 1 ABC 5 1 XYZ 4 2 DEF 3 2 DEF 4 1 DEF 6 1 MNO 5 5 JKL 3 2 JKL 4 2 PQR 12 1 For each unique entry in column 1 I want to add values in column 2 and column3 o/p ABC 8 2 XYZ 4 2

## 7. Shell Programming and Scripting

if header line starts with chr1 and span 10 print chr1 and the original values and ov+10 and viceversa input variableStep chrom=chr1 span=10 191 1 201 18 211 1 variableStep chrom=chr2 span=10 191 11 201 1 211 12 output chr1 191 201 1 chr1 201 211 ...

## Command to add 1000 spaces to end of line

hi, could anyone tell me the command to append spaces at the end of the line. for example, i need 1000 spaces after the word "helloworld" echo "helloworld " i need to achieve this in someother way hardcoding 1000 spaces is not practical. as i am totally new...

## Help: How do I ADD non-integer (decimal) values?

I am trying to create a script that will read from a file two non-integer values (decimals) and add those values together. For example, I want to add 1.51 and -2.37 together and get the sum. Any ideas? Thanks!

## How to add two large values

Hi, Gives me wrong value when, \$ echo `expr 2221753117 + 299363384` -1773850795 How to overcome this? Appreciate any help on this. -Om