The standard way to perform an increasing numeric sort on the 2nd field in a comma separated file would be:
And the -g option is an extension not mentioned by the standards.
As Aia said, if you don't show us a sample of the data you're trying to sort and the sorted output you're hoping to get from that sample, it is hard for us to guess at why sort -n isn't working for you. Especially since you haven't shown us a sort command using the -n option that isn't working for you.
Ok here it is not sorting properly. 14 and several other numbers should not be as low as they are.
Hello all
I have data like below where the column with values (PRI, SEC ) is the char field and the rest are Numeric Fields.
200707,9580,58,7,2,1,PRI,1,1,137,205594,0,5,10,-45.51,-45.51
200707,9580,58,7,2,1,SEC,1,1,137,205594,0,5,10,-45.51,45.51... (1 Reply)
Hi,
Could someone please help me with this? I have a text file that has fields seperated by comma. The last column in it has multiple values seperated by "|". I need to sort values in the last column seperated by pipe..is there any way I can do this through script?
Sample text file -
... (7 Replies)
Hi All,
I have a file which is having 3 columns as (string string integer)
a b 1
x y 2
p k 5
y y 4
.....
.....
Question:
I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Hi,
I am unable to sort data on the first field
$cat t
Jim,212121,Seattle
Bill,404404,Seattle
Steve,246810,Nevada
Scott,212277,LosAngeles
Jim,212121,Ohio
sort -t"," -k1,2 t
Bill,404404,Seattle
Jim,212121,Ohio
Jim,212121,Seattle
Scott,212277,LosAngeles
Steve,246810,Nevada (7 Replies)
dear all,
i have .dat files named as:
34.dat
2.dat
16.dat
107.dat
i would like to sort them by their filenames as:
2.dat
16.dat
34.dat
107.dat
i have tried numerous combinations of sort and ls command (in vain) to obtain :
107.dat
16.dat
2.dat
34.dat (1 Reply)
Hi
I am using this
cat substitutionFeats.txt | gawk '{$0=gensub(/\t/,"blabla",1);print}' | gawk '{print length, $0}' | sort -n | sort -r
and the "sort -n" command doesn't work as expected: it leads to a wrong ordering:
64 Adjustable cuffs
64 Abrasion-
64 Abrasion pas
647 Sanitized 647... (4 Replies)
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)
How could i take an input file and split the numeric values from the alpha values (123 vs abc) to distinc columns, and if the source is blank to keep it blank (null) in both of the new columns:
So if the source file had a column like:
Value:
|1 |
|2.3|
| |
|No|
I would... (7 Replies)
Hi All,
I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7
I tried
awk '{gsub("8","7",$35)}1' infile > outfile ----> not working
sed -i 's/8/7'g' infile --- it is replacing all... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies
LEARN ABOUT DEBIAN
oggz-sort
oggz-sort(1) General Commands Manual oggz-sort(1)NAME
oggz-sort -- Sort the pages of an Ogg file in order of presentation time.
SYNOPSIS
oggz-sort [-o filename | --output filename ] filename
oggz-sort [-h | --help ] [-v | --version ]
Description
oggz-sort sorts an Ogg file, interleaving pages in order of presentation time. It correctly interprets the granulepos timestamps of Ogg
CELT, CMML, Dirac, FLAC, Kate, PCM, Speex, Theora and Vorbis bitstreams. Run oggz-known-codecs(1) for a full list of codecs known by the
installed version of oggz.
Some encoders produce files with incorrect page ordering; for example, some audio and video pages may occur out of order. Although these
files are usually playable, it can be difficult to accurately seek or scrub on them, increasing the likelihood of glitches during playback.
Players may also need to use more memory in order to buffer the audio and video data for synchronized playback, which can be a problem when
the files are viewed on low-memory devices.
Some older Ogg encoders also produce pages which incorrectly have granulepos timestamps recorded that shouldn't be: pages which have no
completed packets must have a granulepos of -1. oggz-sort will correct such granulepos during the process of sorting.
The tool oggz-validate can be used to check the relative ordering of packets in a file, and also to detect incorrect granulepos on pages
with no completed packets. If either of these errors are reported, or use oggz-sort to fix the problem.
Options
oggz-sort accepts the following options:
Miscellaneous options
-o filename, --output filename
Write output to the specified filename instead of printing it to standard output.
-h, --help
Display usage information and exit.
-v, --version
Output version information and exit.
EXAMPLES
Correct the page ordering in broken.ogv:
oggz sort -o fixed.ogv broken.ogv
AUTHOR
Conrad Parker January 25, 2008;
COPYRIGHT
Copyright (C) 2008 Annodex Association
SEE ALSO oggz-validate(1), oggz-merge(1), oggz-dump(1), oggz-diff(1), hogg(1)oggz-sort(1)