Sorting based on the second field Post: 302780769

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting on last field

Hello I am trying to sort on the last field and it seems to have lost ideas on what to do. the file am sorting looks like this Tan\da\1223 hey\1234 two\three\think\4579 i want to sort on the last fields (1223, 1234 and 4579). thank you

2. Shell Programming and Scripting

Find top N values for field X based on field Y's value

I want to find the top N entries for a certain field based on the values of another field. For example if N=3, we want the 3 best values for each entry: Entry1 ||| 100 Entry1 ||| 95 Entry1 ||| 30 Entry1 ||| 80 Entry1 ||| 50 Entry2 ||| 40 Entry2 ||| 20 Entry2 ||| 10 Entry2 ||| 50...

3. UNIX for Dummies Questions & Answers

awk - Summing a field based on another field

So, I need to do some summing. I have an Apache log file with the following as a typical line: 127.0.0.1 - frank "GET /apache_pb.gif HTTP/1.0" 200 2326 Now, what I'd like to do is a per-minute sum. So, I can have awk tell me the individual minutes, preserving the dates(since this is a...

4. Shell Programming and Scripting

Sorting file by a field, and then by another field.

Hi all, Sorry the title is a mess, but did not find a better description at the time. So here is my problem: I have an input file: 8:Mass40s -- 0 48:Mass40s -- 0 67:Mass40s -- 0 86:Mass40s -- 0 105:Mass40s -- 0 9:Mass -- 1 49:Mass -- 86...

5. Shell Programming and Scripting

Sorting on two fields time field and number field

Hi, I have a file that has data in it that says 00:01:48.233 1212 00:01:56.233 345 00:09:01.221 5678 00:12:23.321 93444 The file has more line than this but i just wanted to put in a snippet to ask how I would get the highest number with time stamp into another file. So from the above...

6. UNIX for Dummies Questions & Answers

Sorting data in file based on field in another file

Hi, I have two files, one of which I would like to sort based on the order of the data in the second. I would like to do this using a simple unix statement. My two files as follows: File 1: 12345 1 2 2 2 0 0 12349 0 0 2 2 1 2 12350 1 2 1 2 2 2 . . . File2: 12350...

7. Shell Programming and Scripting

sorting based on a field

the below is sorted as it is. the fields that i'm interested in are the 4th and 5th field. i want to sort the based on the 4th field. my past attempt to do this was to do something like this: awk '{print $4}'| awk '{print $1":"$2}' datafile | sort | uniq however, if i do that, i lose...

8. Shell Programming and Scripting

awk to update value in field based on another field

In the tab-delimeted input file below I am trying to use awk to update the value in $2 if TYPE=ins in bold, by adding the value of HRUN= in italics. In the below since in line 1 TYPE=ins the 117282541 value in $2 has 6 added because that is the value of HRUN=. Hopefully the awk is a start but I...

9. Shell Programming and Scripting

awk to adjust coordinates in field based on sequential numbers in another field

I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines. If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line...

10. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

Hi, So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple...

LEARN ABOUT XFREE86

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)