Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: reverse sort
Top Forums Shell Programming and Scripting reverse sort Post 302113731 by markjason on Monday 9th of April 2007 06:12:18 PM
Old 04-09-2007
reverse sort
Hello,
How do i sort a csv file. i should be sorting column1(varchar),column2*(varchar) in ascending and column4 in descending order(numeric datatype).

I tried few combinations of sort, but doesn't seem to be getting the right result.

sort -t "," -k 1 -k 2 -k 4nr file
any help is appreciated.

Mark.
This User Gave Thanks to markjason For This Post:
 

10 More Discussions You Might Find Interesting

1. 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

2. UNIX for Dummies Questions & Answers

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... (7 Replies)
Discussion started by: sivakumar.rj
7 Replies

3. Shell Programming and Scripting

reverse sort file

Hi all I am trying to numerically reverse sort a file but I seem to be having trouble. Example of file contents: text1,1 text2,-1 text3,0 I can sort using sort -k 2n -t, filename without any problems. However I want my results in descending order but using -r in my command... (2 Replies)
Discussion started by: pxy2d1
2 Replies

4. 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

5. UNIX for Advanced & Expert Users

Script to sort the files and append the extension .sort to the sorted version of the file

Hello all - I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
Discussion started by: pankaj80
3 Replies

6. Shell Programming and Scripting

Reverse sort

Hello, I have a large list of names and would like to do a reverse sort on them i.e. the sort should be by the ending and not by the beginning of the word. I had written in awk a small script but it does wrong things { for(i=length($0);i>=1;i--) printf("%s/n",substr($0,i,1)); } Could anyone... (3 Replies)
Discussion started by: gimley
3 Replies

7. Shell Programming and Scripting

Reverse sort on delimited chunks within a file

Hello, I have a large file in which data of names is sorted according to their homographs. The database has the following structure:Each set of homographs with their corresponding equivalents in Devanagari is separated out from the next set by a hard return. An example will make this... (12 Replies)
Discussion started by: gimley
12 Replies

8. Shell Programming and Scripting

Help with sort word and general numeric sort at the same time

Input file: 100%ABC2 3.44E-12 USA A2M%H02579 0E0 UK 100%ABC2 5.34E-8 UK 100%ABC2 3.25E-12 USA A2M%H02579 5E-45 UK Output file: 100%ABC2 3.44E-12 USA 100%ABC2 3.25E-12 USA 100%ABC2 5.34E-8 UK A2M%H02579 0E0 UK A2M%H02579 5E-45 UK Code try: sort -k1,1 -g -k2 -r input.txt... (2 Replies)
Discussion started by: perl_beginner
2 Replies

9. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

Hi Experts, I have a filelist collected from another server , now want to sort the output using date/time stamp filed. - Filed 6, 7,8 are showing the date/time/stamp. Here is the input: #---------------------------------------------------------------------- -rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies

10. 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

LEARN ABOUT FREEBSD

slapo-valsort

SLAPO-VALSORT(5)						File Formats Manual						  SLAPO-VALSORT(5)

NAME

       slapo-valsort - Value Sorting overlay to slapd

SYNOPSIS

       /etc/ldap/slapd.conf

DESCRIPTION

       The  Value Sorting overlay can be used with a backend database to sort the values of specific multi-valued attributes within a subtree. The
       sorting occurs whenever the attributes are returned in a search response.

       Sorting can be specified in ascending or descending order, using either numeric or alphanumeric sort methods.  Additionally,  a	"weighted"
       sort  can  be specified, which uses a numeric weight prepended to the attribute values.	The weighted sort is always performed in ascending
       order, but may be combined with the other methods for values that all have equal weights. The weight is specified by prepending an  integer
       weight  {<weight>} in front of each value of the attribute for which weighted sorting is desired. This weighting factor is stripped off and
       never returned in search results.

CONFIGURATION

       These slapd.conf options apply to the Value Sorting overlay.  They should appear after the overlay directive.

       valsort-attr <attribute> <baseDN> (<sort-method> | weighted [<sort-method>])
	      Configure a sorting method for the specified attribute in the subtree rooted at baseDN.  The sort-method may be one of alpha-ascend,
	      alpha-descend, numeric-ascend, or numeric-descend.  If the special weighted method is specified, a secondary sort-method may also be
	      specified. It is an error to specify an alphanumeric sort-method for an attribute with Integer or NumericString syntax, and it is an
	      error to specify a numeric sort-method for an attribute with a syntax other than Integer or NumericString.

EXAMPLES

	    database bdb
	    suffix dc=example,dc=com
	    ...
	    overlay valsort
	    valsort-attr member ou=groups,dc=example,dc=com alpha-ascend

FILES

       /etc/ldap/slapd.conf
	      default slapd configuration file

SEE ALSO

       slapd.conf(5), slapd-config(5).

ACKNOWLEDGEMENTS

       This module was written in 2005 by Howard Chu of Symas Corporation. The work was sponsored by Stanford University.

OpenLDAP							    2012/04/23							  SLAPO-VALSORT(5)
All times are GMT -4. The time now is 09:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy