split my file

[papori]

Hi all,
i am looking for a way to split file into 4 groups.
my file looks like:
c0 c1 c2 c3
name1 1 3 5
name2 144 36 53
name3 14 10 7
name4 11 12 8

Tab is separate between fields.
i want group1 to be all names where c1>c2>c3
the result should be name3
group2 to be c1<c2<c3
result name1
group3 to be c1>c2<c3
result name2
group4 to be c1<c2>c3
result name4

Any idea of easy way?
Perl/bash..

Thanks,
Pap

[flyingfsck]

Easy way?

$ gnumeric filename

[papori]

Thanks,
that is easy..
But, what if i have 100 files?

[flyingfsck]

Write a gnumeric macro!

[mrbrown79]

Originally Posted by papori

Hi all,
i am looking for a way to split file into 4 groups.
my file looks like:
c0 c1 c2 c3
name1 1 3 5
name2 144 36 53
name3 14 10 7
name4 11 12 8

Tab is separate between fields.
i want group1 to be all names where c1>c2>c3
the result should be name3
group2 to be c1<c2<c3
result name1
group3 to be c1>c2<c3
result name2
group4 to be c1<c2>c3
result name4

Any idea of easy way?
Perl/bash..

Thanks,
Pap

awk should be able to do that. E.g.

awk '{if($2>$3 && $3>$4) print $1 >> "group1.txt";if($2<$3 && $3<$4) print $1 >> "group2.txt" }' yourfile.txt

[george_toolan]

Please note that the case "=" isn't handled, so if you have any lines with c1 == c2 or c2 == c3 they won't appear in any of the output files.