List-to-Range of Numbers - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
List-to-Range of Numbers

google unix.com

UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
match range of different numbers by AWK	repinementer	Shell Programming and Scripting	54	09-14-2009 04:07 AM
read numbers from file and output which numbers belongs to which range	thepurple	Shell Programming and Scripting	6	05-13-2009 07:07 AM
Using grep on a range of numbers	ProgChick2oo9	UNIX for Dummies Questions & Answers	1	03-15-2009 03:58 PM
Fill in missing numbers in range	bistru	Shell Programming and Scripting	5	05-17-2006 03:42 AM
grep numbers range	azmathshaikh	Shell Programming and Scripting	1	08-08-2005 08:45 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

09-19-2009

Gussifinknottle Gussifinknottle is offline

Registered User

Join Date: Jan 2009

Posts: 20

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

Bookmarks

« Using Awk within awk to read all files in directory | How to correctly use an echo inside an echo? »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 11:59 AM.