Hi ,
I need to sort a file based on multiple columns All the columns are of varchar type
can any one give me the command to sort for varchar columns?
Thanks (3 Replies)
Please help to sort columns in this file:
a b d f c e
1 4 10 16 7 13
2 5 11 17 8 14
3 6 12 18 9 15
I need to sort COLUMNS (so sort command doesn't work) like this:
a b c d e f
1 4 7 10 13 16
2 5 8 11 14 17
3 6 9 12 15 18
I know sed can do it but don't know how... :( (7 Replies)
Hi, Please I need urgent help in sorting below data, I had similar post but there was a kind of space in between the data but now there is no space and I have tried adjusting the old script to work but it didn't.
here are the data;
traceroute to 2001:1ba0:2a0:5965:0:30:24:1... (6 Replies)
Hi all,
I'm using Solaris 10, and need help in sorting the below output from the syslog file in descending rather than ascending order.
I would like both the hostname and message columns to be sorted, but right now only the message is sorted and the count column, whose order I would like... (2 Replies)
Hi,
We have a requirement of need to sort a file based on fields 1,3 and 4. I tried with sort command however it is not giving expected output, can we achieve any other way? Please let me know ASAP.
File
a e w a
a b a a
a a d g
a a h h
c d a e
a a a w
Output
a b a a
a a a w
a a d... (4 Replies)
I have a space delimited text file that I would like to sort by multiple columns. First I want to sort by column 1, then by column 2. Both columns are numerical. Thanks! (1 Reply)
Hi
I have a text file that has four columns (Logonid,First Name,Last Name,Status)
Logonid First Name Last Name Status
abc2 Fred Mercury Inactive
abc1 John Deacon Active
abc3 Roger Taylor Active
abc4 Brian ... (2 Replies)
Hello!
So ive been presented with this comma-delimited file:
I need a print to look as below
"
lastname, phone_number, zip
for every person with a last name starting with the letter H, I
only with a 650-area code phone number. output should be sorted by reverse ZIP code "
I only have... (5 Replies)
Hi, I have a tab delimited columnar file where I want to remove lines wherever two particular columns match. so for this file, I want to toss the lines where columns 1 and 2 match:
a a 1 3
a b 2 4
b b 3 5
because there are matches column 1 and 2 in lines 1 and 3, I would like a script to... (2 Replies)
I have a file which contains following lines:
0114714710147 09013 00025.00D986532147
2814714710147 09013 00045.00D985532147
Now, I need to sort the file with above bold and colured one. Means:
first sorting will be done by: 147147 then by 10147 09013 after that by 986532147.
The... (2 Replies)
Discussion started by: George1234
2 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)