G'day rkk,

Welcome to the monastery.

You seem to have got off on the wrong foot somewhat. Here's a few tips:

• How do I post a question effectively? — essential reading.
• How (Not) To Ask A Question — this includes the "Do Your Own Work" section that LanX was pointing you to.
• How do I change/delete my post? — it would have been better to update your original post with the code rather than creating two new (identical) reply nodes; this tells you how to do that.

Here's the guts of the code I might have used to tackle this problem:

#!/usr/bin/env perl -l

use strict;
use warnings;

my $first;

print join ' ' => @$_ for
    grep { $_->[-1] - $first <= 500 }
    sort { $b->[-1] <=> $a->[-1] }
    map { $first = $_->[-1] unless $first; $_ }
    map { [ split ] } <DATA>;

__DATA__
ID1 ch1 70 mir abc xyz ch2 2050
ID4 ch1 120 mir abc xyz ch2 2025
ID2 ch1 90 mir abc xyz ch2 4000
ID3 ch1 100 mir abc xyz ch2 2045
[download]

After excluding the ID2 line, your data was already sorted. I've changed the order of the lines under __DATA__ to show that the sort works.

Here's the output:

$ pm_sort_exclude.pl
ID1 ch1 70 mir abc xyz ch2 2050
ID3 ch1 100 mir abc xyz ch2 2045
ID4 ch1 120 mir abc xyz ch2 2025
[download]

Update: I left the 500 out of the comparison. Fixed: s/$_->[-1] <= $first/$_->[-1] - $first <= 500/

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.