Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

sort command help needed.

Login to Discuss or Reply to this Discussion in Our Community

 
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