05-11-2009
read numbers from file and output which numbers belongs to which range
Howdy experts,
We have some ranges of number which belongs to particual group as below.
HTML Code:
GroupNo StartRange EndRange
Group0125 935300 935399
Group2006 935400 935476
937430 937459
Group0324 935477 935549
937480 937499
Group0404 935550 935625
937800 937879
Now I have a list of numbers in a file. Script will read the list of numbers in the file and output which numbers belongs to which group.
Example File1:
935303455
935479875
935477987
937499000
937492355
937860439
935393444
I need your help to write this script.
Best regards,
purple
Last edited by thepurple; 05-11-2009 at 02:14 PM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi im new to unix and need to find a way to grep the top 5 numbers in a file and put them into another file. For example my file looks like this
abcdef 50000
abcdef 45000
abcdef 40000
abcdef 35000
abcdef 30000
abcdef 25000
abcdef 20000
abcdef 15000
abcdef 10000
and so on...
How can... (1 Reply)
Discussion started by: ProgChick2oo9
1 Replies
2. Shell Programming and Scripting
I have a text file in the following format
....
START
1,1
2,1
3,1
..
..
9,1
10,1
END
....
I want to change to the output to
....
START
1,1
2,1
3,1
.. (4 Replies)
Discussion started by: VNR
4 Replies
3. Shell Programming and Scripting
I am trying to add free and used memory (so that i can compute percentage used)of remote nodes using shell script. I use the openssh-server,expect tool and ssh script.
1)login.txt (info of nodes):
ip1|username|password
ip2|username|password
.
.
.
3)sshlogin.sh
#!/bin/bash ... (1 Reply)
Discussion started by: marmik1903
1 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I have a column where there are values from 1 to 150.
I want to get the frequency of values in the following ranges:
1-5
6-10
11-15
....
....
....
146-150
How can I do this in a for loop?
Thanks,
Guss (1 Reply)
Discussion started by: Gussifinknottle
1 Replies
5. UNIX for Dummies Questions & Answers
Hi I have a data file with two columns which looks like:
1 42
2 40
3 55
4 50
5 38
6 49
7 33
8 46
9 39
10 33
11 33
12 26
13 46
14 44
15 55
16 54
17 30
18 32 (7 Replies)
Discussion started by: marhuu
7 Replies
6. Shell Programming and Scripting
Hello All,
I am having problem to find what is the smallest number from 90% of highest numbers from all numbers in file. I am having file with thousands of lines and hundreds of columns.
I am familiar mainly with bash but I am open to whatever suggestion witch will lead to the solutions.
If I... (11 Replies)
Discussion started by: Apfik
11 Replies
7. Shell Programming and Scripting
I am trying to make a script to read marks from a file then find out how many of them are above 40 (passing marks). However my script is getting stuck at "read num". I dont understand whats the problem. Any help will be much appreciated.
#!/bin/bash
set -x
count=0; countP=0; PASSMK=40... (6 Replies)
Discussion started by: vish6251
6 Replies
8. Shell Programming and Scripting
Hi,
I'm trying to match a filename that could be called anything from vout001 to vout252 and was trying to do a small test but I'm not getting the result I thought I would..
Can some one tell me what I'm doing wrong?
*****@********>echo $mynumber ... (4 Replies)
Discussion started by: Jazmania
4 Replies
9. Shell Programming and Scripting
Hi again. Sorry for all the questions — I've tried to do all this myself but I'm just not good enough yet, and the help I've received so far from bartus11 has been absolutely invaluable. Hopefully this will be the last bit of file manipulation I need to do.
I have a file which is formatted as... (4 Replies)
Discussion started by: crunchgargoyle
4 Replies
10. UNIX for Beginners Questions & Answers
Hello,
I have the following script
while read id fraction
do
sambamba -h -f bam -t 10 --subsampling-seed=50 -s $frac ${id}.bam -o ${id}.out.bam
done < fraction.txt
where fraction.txt has two columns (id,fraction) and 50 rows
I am unable to run this as bash is not able to read the second... (2 Replies)
Discussion started by: nans
2 Replies
LEARN ABOUT DEBIAN
numrange
NUMRANGE(1) User Contributed Perl Documentation NUMRANGE(1)
NAME
numrange - Print out a range of numbers for use in for loops and such.
SYNOPSIS
numrange [-dhV] /<expression>/
DESCRIPTION
numrange will print out a list of numbers based on an expression that you specify. This is useful for making a list of numbers for use in
for loops and so on. Ranges are inclusive. Ranges of numbers are specified using the .. operator, like this /20..50/, which means all
integers from 20 to 50 inclusive. More complex expressions can be generated using the commas and the 'i' increment operator.
OPTIONS
-e <set> Exclude the <set> of numbers from the range output. <set>
is a set of numbers separated by commas.
-n <n> Use <n> as the separator between numbers. By default, it
will use a space. Use '
' or \n for a newline character or
use the -N option.
-N Just a quick option for using a newline as the separator.
-h Help: You're looking at it.
-V Increase verbosity.
-d Debug mode. For developers
EXAMPLES
All numbers from 1 to 10.
$ numrange /1..10/
1 2 3 4 5 6 7 8 9 10
From 10 to 1. Counting down.
$ numrange /10..1/
10 9 8 7 6 5 4 3 2 1
From 1 to 10 and from 15 to 20.
$ numrange /1..10,15..20/
1 2 3 4 5 6 7 8 9 10 15 16 17 18 19 20
Even numbers from 0 to 10
$ numrange /0..10i2/
0 2 4 6 8 10
Odd numbers. Notice the starting number in the range expression.
$ numrange /1..10i2/
1 3 5 7 9
Factors of 3 between 99 and 120.
$ numrange /99..120i3/
99 102 105 108 111 114 117 120
Decimal numbers
$ numrange /1.1..2.5i0.1/
1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 2.4 2.5
And negative numbers too.
$ numrange /1.0..-2.0i0.3/
1 0.7 0.4 0.1 -0.2 -0.5 -0.8 -1.1 -1.4 -1.7 -2
You can also pad numbers when you are counting up. This is
a trick of how the Perl programming language deals with ranges:
$ numrange /01..15/
01 02 03 04 05 06 07 08 09 10 11 12 13 14 15
BUGS
Even though you can do zero padding on simple ranges, like 001..100, it will not pad zeros on complex ranges like 001..100i2, or for
counting downwards.
SEE ALSO
seq(1), numaverage(1), numbound(1), numinterval(1), numnormalize(1), numgrep(1), numprocess(1), numsum(1), numrandom(1), numround(1)
COPYRIGHT
numrange is part of the num-utils package, which is copyrighted by Suso Banderas and released under the GPL license. Please read the
COPYING and LICENSE files that came with the num-utils package
Developers can read the GOALS file and contact me about providing
submitions or help for the project.
MORE INFO
More info on numrange can be found at:
http://suso.suso.org/programs/num-utils/
perl v5.10.1 2009-10-31 NUMRANGE(1)