hmm....The output you posted is in fact sorted on the second field. Notice the penultimate line with "50034", which moved up in the output.
Still, there are only two distinct keys in your input and the question arises how sort should handle lines with identical keys. If you don't want the lines with identical second fields to be sorted upon the contents of the first field (or in a different manner, like reversed) you should define a compund sort key based on several fields.
Take your second sort key for example: it says the lines should be sorted upon a key composed from a string starting at the first character of the second field to the 6th character of the second field. Therefore, the sorting routine of the "sort" command "sees" these keys (i include line numbers for reference):
How is it supposed to determine, if, for instance, line 2 should go before or after line 3? This is why the file seems to be sorted based on field 1, but this is only the case because so many contents of your specified key are identical and for these the default sort (start of line) kicks in.
If you want to override this define a sort key which leads to distinct sort key contents.
Tip: In your "-k ..." definition you don't have to keep the line order. You may specify for instance "first field 2, then field 4, only then field 3" as well.
Hi,
I want a list of entries in 3 space delimited columns. I want to sort entries based on the very first column. Rows can't be changed. For example:
If I have...
Abc Abc Acc
Bca Bda Bdd
Cab Cab Cbc
Dbc Dca Dda
Abc Abc Acc
the output should be...
Abc Abc Acc
Abc Abc Acc
Bca... (7 Replies)
Hi,
I have a requirement whereby I have to sort a flat file based on Multiple Columns (similar to ORDER BY Clause of Oracle). I am getting 10 columns in the flat file and I want the file to be sorted on 1st, 3rd, 4th, 7th and 9th columns in ascending order. The flat file is pipe seperated.
Any... (15 Replies)
Hello,
I have data where words are separated by a delimiter. In this case "="
The number of delimiters in a line can vary from 4to 8. The norm is 4.
Is it possible to have a script where the file could be separated starting with highest number of delimiters and ending with the lowest
An... (8 Replies)
Hello,
I have a file with multiple entries.
@SFGF-GA2-1_58:5:36:11009:999#0/1
NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
+SFGF-GA2-1_58:5:36:11009:999#0/1
################################################################################... (10 Replies)
i need to write a bash script that recive a list of varuables
kaka pele ronaldo beckham zidane messi rivaldo gerrard platini
i need the program to print the longest word of the list.
word in the output appears on a separate line and word order in the output is in the order Llachsicografi costs.... (1 Reply)
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... (2 Replies)
Hi team,
We have few files landing to our server based on sequence number. These files have to be processed in the sequence number order. Once the sequence number has reached its maximum, the files with sequence number 0000 has to be processed.
For example:
IN9997
IN9998
IN9999
IN0000... (7 Replies)
Oracle Enterprise Linux 6
This is my file. Two fields separated by space
$ cat testfile.txt
MARCH9 MARCH4
MARCH1 MARCH5
MARCH2 MARCH326
MARCH821 MARCH7
MARCH6 MARCH2
$
$
The following numeric sort, based on the first field's 6th character works as expected.
$
$ sort -n -k 1.6... (7 Replies)
Hello ,
I have to write a bash script. I will explain the logic based on a scenario.
Scenario :
Suppose I have few files in a Folder X :
FILE_201508.list
FILE_201510.list
FILE_201507.list
abc_201510.csv
xyz_201508.csv
abc_201507.csv
def_201507.csv
1) Now ,... (3 Replies)
Hi All
I have a requirement to list all the files in chronological order based on the date value in the file name.For ex if I have three files as given below
ABC_TEST_20160103_1012.txt
ABC_TEST_20160229_1112.txt
ABC_TEST_20160229_1112.txt
I have written code as given below to list out... (2 Replies)
Discussion started by: ginrkf
2 Replies
LEARN ABOUT DEBIAN
sort-dctrl
SORT-DCTRL(1) Debian user's manual SORT-DCTRL(1)NAME
sort-dctrl - sort Debian control files
SYNOPSIS
sort-dctrl [options] [ file ... ]
sort-dctrl --copying | --help | --version | -ChV
DESCRIPTION
The sort-dctrl program sorts Debian control files according to specified criteria.
A Debian control (dctrl) file is a semistructured single-table database stored in a machine-parseable text file. Such a database consists
of a set of records; each record is a mapping from field names to field content. Textually, records are separated by empty lines, while
each field is encoded as one or more nonempty lines inside a record. A field starts with its name, followed by a colon, followed by the
field content. The colon must reside on the first line of the field, and the first line must start with no whitespace. Subsequent lines,
in contrast, always start with linear whitespace (one or more space or tab characters).
The sort-dctrl program recognizes two field types: string fields and version fields. Version fields act also as numeric fields. String
fields are compared according to strict lexicographical octet-by-octet comparison, after ignoring any initial whitespace after the colon.
Version fields are parsed and compared as Debian version numbers. When comparing version numbers, if a field content does not in fact con-
form to the version number syntax, it compares less than any field content that does conform, and equal to any other nonconforming field
content. The sort-dctrl program assumes all fields are string fields unless told otherwise.
You can specify arbitrary number of keys for sorting, using the -k option. The keys are interpreted in a descending order of priority: the
first key specified is primary, the second key specified is secondary, and so on. If two records compare equal under the primary key, then
they are compared under the secondary key, and so on. If no keys are specified, a default key is assumed (the "Package" field with no mod-
ifiers).
OPTIONS -k keyspec, --key-spec=keyspec
Specify one or more keys for sorting. You may specify this option any number of times. The keyspec argument consists of a comma-
separated list of key specifications. Each key specification consists of the name of the field that serves as the key, optionally
followed by a colon and key modifiers. The following key modifiers are supported:
r Invert the comparison for this key, reversing the sorting order.
v Treat this field as a version number field.
n Treat this field as numeric, which currently is synonymous with v.
-q, --quiet, --silent
Output nothing to the standard output stream. Instead, exit immediately after finding the first match.
-l level, --errorlevel=level
Set log level to level. level is one of fatal, important, informational and debug, but the last may not be available, depending on
the compile-time options. These categories are given here in order; every message that is emitted when fatal is in effect, will be
emitted in the important error level, and so on. The default is important.
-V, --version
Print out version information.
-C, --copying
Print out the copyright license. This produces much output; be sure to redirect or pipe it somewhere (such as your favourite
pager).
-h, --help
Print out a help summary.
EXAMPLES
Here are some sample invocations of the program:
sort-dctrl /var/lib/dpkg/available
Output the dpkg available file sorted by the package name.
sort-dctrl -k Version:v /var/lib/dpkg/available
Output the dpkg available file sorted in ascending order of version numbers.
sort-dctrl -k Version:vr /var/lib/dpkg/available
Output the dpkg available file sorted in descending order of version numbers.
sort-dctrl -k Package,Version:v /var/lib/dpkg/available
Output the dpkg available file sorted primarily in ascending order of package names and secondarily in descending order of version
numbers.
sort-dctrl -k Installed-Size:n,Size:nr /var/lib/dpkg/available
Output the dpkg available file sorted primarily in ascending order of installation sizes and secondarily in descending order of
package sizes.
AUTHOR
The program and this manual page were written by Antti-Juhani Kaijanaho <ajk@debian.org>.
SEE ALSO
Debian Policy Manual. Published as the Debian package debian-policy. Also available in the Debian website.
grep-dctrl(1)Debian Project 2005-06-08 SORT-DCTRL(1)