sort -reverse order


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers sort -reverse order
# 1  
Old 09-23-2008
sort -reverse order

I need to sort the particular column only in reverse order how i can give it..

if i give the -r option the whole file is getting sorted in reverse order.

1st 2nd col 3rd
C col 4th col 5th col
-------------------------------------------
C 1100002814701 1 1100002808901 050919
C 1100002814801 1 1100002809001 070919
C 1100002814901 1 1100002809101 060919

I need to sort the 2nd col by ascending order and 5th column in reverse (descending) order..... how i can use the sort......is it by using the old key or new key defintion.
# 2  
Old 09-23-2008
What have you tried?

sort -r -k 4,4 ?
# 3  
Old 09-23-2008
i used sort +0.1 -0.14 -r +0.28 -0.33. It reverses the whole records.
# 4  
Old 09-23-2008
Quote:
Originally Posted by sivakumar.rj
i used sort +0.1 -0.14 -r +0.28 -0.33. It reverses the whole records.
Of course, thats the idea: sorting is displaying using a sort criteria, not modifying records...
in your case sorting in reverse order the 4th field:

Code:
 $ sort -r -k 4,4 00aa 
C 1100002814901 1 1100002809101 060919
C 1100002814801 1 1100002809001 070919
C 1100002814701 1 1100002808901 050919

# 5  
Old 09-23-2008
$ sort -r -k 4,4 00aa

what does this aa represent actually??

i need to sort the 2nd column in ascending and 5th column in descending order.....actually saying there will be no spaces between the records..
to differentiate the records i have given like this......

C 1100002814901 1 1100002809101 060919
C 1100002814801 1 1100002809001 070919
C 1100002814701 1 1100002808901 050919
# 6  
Old 09-23-2008
I may have not understood:
Is the line
C 1100002814901 1 1100002809101 060919
a record?
# 7  
Old 09-23-2008
Data before sorting...
Code:
C 1100002814801 1 1100002809001 070919
C 1100002814901 1 1100002809101 060919
C 1100002814701 1 1100002808901 050919
C 1100002814701 1 1100002808901 050920

Data after sorting...
Code:
sort -n -k2,2 -k5,5r file
C 1100002814701 1 1100002808901 050920
C 1100002814701 1 1100002808901 050919
C 1100002814801 1 1100002809001 070919
C 1100002814901 1 1100002809101 060919

Is this what you want??
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Issues with sorting in reverse order

I have a unix script that outputs a summary file to the mac desktop. The file is called summary.txt I am trying to configure such so that the summary.txt file lists the content contained within such in reverse sort order. I have used sort -r but it does not seem to work. I would be... (8 Replies)
Discussion started by: Braveheart
8 Replies

2. UNIX for Dummies Questions & Answers

[Solved] Reverse the order of a list of file names (but not sort them alphabetically or numerically)

Hello all, I have a list of file names in a text document where each file name consists of 4 letters and 3 numbers (for example MACR119). There are 48 file names in the document (they are not in alphabetical or numerical order). I would like to reorder the list of names so that the 48th name is... (3 Replies)
Discussion started by: MDeBiasse
3 Replies

3. Shell Programming and Scripting

Sorting strings in reverse order

Hello, I have a large database of words and would like them sorted in reverse order i.e. from the end up. An example will make this clear: I have tried to write a program in Perl which basically takes the string from the end and tries to sort from that end but it does not seem... (5 Replies)
Discussion started by: gimley
5 Replies

4. Shell Programming and Scripting

print in reverse order

Hi, I want to print the item in reverse order such that the output would look like 00 50 50 23 40 22 02 96 Below is the input: 00 05 05 32 04 22 20 69 Video tutorial on how to use code tags in The UNIX and Linux Forums. (5 Replies)
Discussion started by: reignangel2003
5 Replies

5. UNIX for Dummies Questions & Answers

printing fields in reverse order

command/script(apart from awk) to print the fields in reverse order that is last field has to come first and so on and first field has to go last Input store-id date sale ............. ............. ... (3 Replies)
Discussion started by: tsurendra
3 Replies

6. UNIX for Dummies Questions & Answers

How to print arguments in reverse order?

Hey all, How do I make a script print its arguments in reverse order? Thanks (5 Replies)
Discussion started by: unclepickle1
5 Replies

7. Shell Programming and Scripting

How to get fields in reverse order?

i am having lines like below seperated by "|" (pipe) abc|xyz 123|567 i have to get the above in reverse order xyz|abc 567|123 Pls help (5 Replies)
Discussion started by: suryanarayana
5 Replies

8. Shell Programming and Scripting

sort a file in reverse order

I a file with log entries... I want to sort it so that the last line in the file is first and the first line is last.. eg. Sample file 1 h a f 8 6 After sort should look like 6 8 f a h 1 (11 Replies)
Discussion started by: frustrated1
11 Replies

9. UNIX for Dummies Questions & Answers

using sed and regex to reverse order???

so i have been trying to learn how to manipulate text on my own and have gotten stumped... let's say i have a text file that says (highly simplified): people ordinary How would swap the order of the words.. I know i need to use sed and some kind of back reference but cannot make it... (2 Replies)
Discussion started by: urtherhoda
2 Replies
Login or Register to Ask a Question