求一LINUX 一PL或Shell代码

[caixicn]

有文件processlist.txt 内容为：
+-------+-------+--------------------+--------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-------+--------------------+--------+---------+------+-------+------------------+
| 22452 | root | 192.168.1.1:37824 | dbname | Sleep | 1 | | |
| 22541 | root | 192.168.1.1:38016 | dbname | Sleep | 0 | | |
| 22543 | root | localhost | | Query | 0 | | show processlist |
| 22544 | root | 192.168.1.1:38021 | dbname | Sleep | 0 | | |
+-------+-------+--------------------+--------+---------+------+-------+------------------+

求过滤出Time>300并且得出相应的ID字段
谢谢！

[fox000002]

哪项是 Time？？

[caixicn]

1
0
0
这项的数字

[wxlfh]

open FH,"<","yourtext.txt";
while (<FH>){
    next unless /\|/;
    @lines = [(split /\|/)[0,5]];
}
@lines = grep {$$_[1]>300} @lines;

好了，现在@lines 数组里面就是了。

[Aylazhang]

awk -F"|" '/\|/{if($7>300)print $7}' your_file

[wxlfh]

open FH,"<","yourtext.txt";
while (<FH>){
    next unless /\|/;
    @lines = [(split /\|/)[0,5]];
}
@lines = grep {$$_[1]>300} @lines;

好了，现在数组@lines 里面的数据就是了。

[wxlfh]

奇怪，刚才发的帖子显示不了，现在怎么有两条了？？