09-19-2009
List-to-Range of Numbers
Hello,
I have two columns with data that look like this:
Col1 Col2
------ -----
a 1
a 2
a 3
a 4
a 7
a 8
a 9
a 10
a 11
b 6
b 7
b 8
b 9
b 14
b 15
b 16
b 17
c 88
c 89
c 90
c 91
c 92
c 95
c 96
c 97
I want to be able to get the range of the numbers in Col2 based on Col1, i.e. the output should look like this:
Col1 Range
a (1-4)
a (7-11)
b (6-9)
b (14-17)
c (88-92)
c (95-97)
Thank you in advance your input!
~Gussi
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to grep a range of numbers in a log file. My log file looks like this:
20050807070609Z;blah blah
That is a combination of yr,month,date,hours,minutes,seconds.
I want to search in the log file events that happened between a particular time.
like between 20050807070000 to 20050822070000... (1 Reply)
Discussion started by: azmathshaikh
1 Replies
2. 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
3. Shell Programming and Scripting
Howdy experts,
We have some ranges of number which belongs to particual group as below.
GroupNo StartRange EndRange
Group0125 935300 935399
Group2006 935400 935476
937430 937459
Group0324 935477 935549
... (6 Replies)
Discussion started by: thepurple
6 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
Dear Friends,
I want to know how to grep for the lines that has a number between given range(start and end).
I have tried the following sed command.
sed -n -e '/20030101011442/,/20030101035519/p'
However this requires both start and end to be part of the content being grepped. However... (4 Replies)
Discussion started by: tamil.pamaran
4 Replies
7. UNIX for Dummies Questions & Answers
I am trying to extract specific information from a large *.sam file (it's originally 28Gb).
I want to extract all lines that are on chr3 somewhere in the range of 112,937,439-113,437,438.
Here is a sample line from my file so you can get a feel for what each line looks like:
seq.4 0 ... (8 Replies)
Discussion started by: genGirl23
8 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
I am getting an argument which specifies the range of numbers. eg: 7-15
Is there a way that i can easily (avoiding loop) print the range of number between and including the specified above.
The above example should translate to 7,8,9,10,11,12,13,14,15 (3 Replies)
Discussion started by: tostay2003
3 Replies
10. Shell Programming and Scripting
Hi,
I'd like to take a list of numbers (with a prefix) and convert to a range, for example:
cn001
cn004
cn016
cn017
cn018
cn019
cn020
cn021
cn031
cn032
cn038
cn042
cn043
cn044
cn045 (5 Replies)
Discussion started by: chrissycc
5 Replies
LEARN ABOUT DEBIAN
ppix::regexp::node::range
PPIx::Regexp::Node::Range(3pm) User Contributed Perl Documentation PPIx::Regexp::Node::Range(3pm)
NAME
PPIx::Regexp::Node::Range - Represent a character range in a character class
SYNOPSIS
use PPIx::Regexp::Dumper;
PPIx::Regexp::Dumper->new( 'qr{[a-z]}smx' )
->print();
INHERITANCE
"PPIx::Regexp::Node::Range" is a PPIx::Regexp::Node.
"PPIx::Regexp::Node::Range" has no descendants.
DESCRIPTION
This class represents a character range in a character class. It is a node rather than a structure because there are no delimiters. The
content is simply the two literals with the '-' operator between them.
METHODS
This class provides no public methods beyond those provided by its superclass.
SUPPORT
Support is by the author. Please file bug reports at <http://rt.cpan.org>, or in electronic mail to the author.
AUTHOR
Thomas R. Wyant, III wyant at cpan dot org
COPYRIGHT AND LICENSE
Copyright (C) 2009-2012 by Thomas R. Wyant, III
This program is free software; you can redistribute it and/or modify it under the same terms as Perl 5.10.0. For more details, see the full
text of the licenses in the directory LICENSES.
This program is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of
merchantability or fitness for a particular purpose.
perl v5.14.2 2012-06-06 PPIx::Regexp::Node::Range(3pm)