sort command help needed.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sort command help needed.
# 1  
Old 03-08-2009
sort command help needed.

Hello,
suppose i have a student.dat file whose format is

studentno studentname semester marks1 marks2 marks3 total

then how can i sort first in semester wise and then total wise? I mean semester wise ranking wise record should be displayed. Semester should be displayed in ascending order (4 , 5. etc ) and result should be descending order(since it is to be displayed rank wise).

i tried with this but couln't succeed

Code:
 sort -n +2 -3 -r +6 -7 student.dat

Thanks in advance Smilie
# 2  
Old 03-08-2009
Hi,

Can you provide a sample file and desired output?
# 3  
Old 03-08-2009
sure

input

Code:
s01 lula 6 75 65 55 195
s02 tutu 6 85 90 90 265
s03 laala 5 55 65 75 195
s04 butterkhor 6 70 70 70 210
s05 kuku 7 50 50 40 140

output
Code:
s03 laala 5 55 65 75 195
s02 tutu 6 85 90 90 265
s04 butterkhor 6 70 70 70 210
s01 lula 6 75 65 55 195
s05 kuku 7 50 50 40 140

# 4  
Old 03-08-2009
Try this:
Code:
sort -k3,3 -k7,7r input.file

# 5  
Old 03-08-2009
thanks a lot ripat Smilie
# 6  
Old 03-09-2009
put your file content into a array, then use below user-defined sort logic to sort your array, then you may get what you want. Smilie

Code:
sub lsort{
	my @t1=split(" ",$_[0]);
	my @t2=split(" ",$_[1]);
	if($t1[2]<$t2[2]){
		return -1;
	}
	elsif($t1[2]>$t2[2]){
		return 1;
	}
	else{
		if($t1[6]<$t2[6]){return 1;}
		elsif($t1[6]>$t2[6]){return -1;}
		else{ return 0;}
	}
}

# 7  
Old 03-18-2009
sort -k3,3 -k7,7r input.file --- this gives

s03 laala 5 55 65 75 195
s02 tutu 6 85 90 90 265
s04 butterkhor 6 70 70 70 210
s01 lula 6 75 65 55 195


Is this sorted???
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sort command help needed

I have a file with three fields of data for example say we have 1420 $12.56 45 3456 $15.89 14 2341 $25.87 32 I need to use a command to show who is getting paid the highest amount to standard output. I am not sure if I should use a sort command or a copy and paste... (1 Reply)
Discussion started by: drew211
1 Replies

2. Shell Programming and Scripting

Is it Possible to sort a list of hexadecimal numbers using "sort" command?

Hello Everybody :) !!!. i have question in mind, is it possible to sort a list of hexadecimal numbers using "sort" command? (9 Replies)
Discussion started by: Kesavan
9 Replies

3. Shell Programming and Scripting

How to Sort Floating Numbers Using the Sort Command?

Hi to all. I'm trying to sort this with the Unix command sort. user1:12345678:3.5:2.5:8:1:2:3 user2:12345679:4.5:3.5:8:1:3:2 user3:12345687:5.5:2.5:6:1:3:2 user4:12345670:5.5:2.5:5:3:2:1 user5:12345671:2.5:5.5:7:2:3:1 I need to get this: user3:12345687:5.5:2.5:6:1:3:2... (7 Replies)
Discussion started by: daniel.gbaena
7 Replies

4. Shell Programming and Scripting

Help needed to sort data

Hello All, Today i have been asking lots of question, hope to become good in scripting soon with all the wonderful advices i get. The question is i want to sort data a get uniq string from it. The code i am using to generate the output is:- check_sun() { for i in $SUN_PLATFORM do $ECHO... (0 Replies)
Discussion started by: asirohi
0 Replies

5. Shell Programming and Scripting

Help needed with Sort and uniq data

Hi All, After Sorting directories and files i have got following output as below, now i only want the strings common in them, so the actual output should be as below in the bottom. How do i do that? Thanks -adsi File to be modified:- Common Components for ----> AA... (4 Replies)
Discussion started by: asirohi
4 Replies

6. UNIX for Dummies Questions & Answers

Help needed to sort multiple columns in one file

Hi, I would like to know given that I have 3 columns. Let say I have first 3 columns to do operation and these operation output is printed out each line by line using AWK and associative array.Currently in the output file, I do a sort by -r for the operation output. The problem comes to... (1 Reply)
Discussion started by: ahjiefreak
1 Replies

7. Shell Programming and Scripting

Help needed to sort file

I have a text file comprising of 3 columns 1. First column - numeric count/frequency of error codes 2. Second column - alphanumeric hyphenated error code 3. Third column - Error code description (alphanumeric) 184 ABCD-954 Errorcodedescription1 35645 DFMS-323 Errorcodedescription2 43534 ... (2 Replies)
Discussion started by: inditopgun
2 Replies

8. UNIX for Dummies Questions & Answers

help needed with sort. pipe and popen()

Suppose I want to find the number of uniq lines in a file. I use the following command: sort file1 | uniq -c | wc -l But if for some reason sort fails, the above command returns 0 as the answer. Why would sort fail ? sort makes use of directories /tmp or /var/tmp to store temporary files.... (7 Replies)
Discussion started by: the_learner
7 Replies

9. UNIX for Dummies Questions & Answers

Sort - Help Needed

Hi, I am facing a small problem while I am doing the sort. Problem Definition: I have a file which has the following data. >cat test.dat zxzxc asdasd qwaxcZa qwaxcA When I do a sort on this file. the result set is asdasd qwaxcA (4 Replies)
Discussion started by: Andysundar
4 Replies
Login or Register to Ask a Question

Featured Tech Videos