I am trying to sort a text file by two keys but the second key should be reversed. Does anyone have any suggestions?
You could sort the files on the first key and then with each segment of the sorted file containing lines where the first key is the same you must sort on the second key.
One long-winded way of doing that would be to use the perl script:
to convert this unsorted file
using this command
to this sorted file
Last edited by risby; 06-30-2008 at 11:29 AM..
Reason: forgot to print the final, saved, segment
how to use the arrow keys in shell scripting. is there any special synatax / command for this.
i just want to use the arrow keys for navigation.
replies appreciated
raguram R (3 Replies)
Hello,
Say I have a file with plain text as shown below. Some columns may have multiple words (like "DESC 1", "DESC 1 2", "DESC 1 2 3"). Let's say the file below has 4 columns: 1st(AA), 2nd(BB), 3rd(DESC 1, ...), 4th(CC 1, ...).
1234567890123456789012345678901234567890
AA BB DESC 1... (1 Reply)
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)
Hi All,
I am having knowledge on some basics of ssh and wanted to know what are the public keys and how can we create and implement it in connecting server.
Please provide the information for the above, it would be helpful for me.
Thanks,
Ravindra (1 Reply)
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)
Can you guys pls take a look at this.
I need to sort this list of numbers as follows:
2nd col first, then 1st col, then 3rd col, all in reverse (highest to lowest).
I'm doing this:
sort -k 2,2nr -k 1,1nr -k 3,3gr
but, as you see, the 3rd col does not get sorted properly.
Any idea... (0 Replies)
sort --random-sort
The full command is
path=`find /testdir -maxdepth 1 -mindepth 1 -type d | ***Some sort of sort function*** | head -1`
I have a list I want to randomly sort. It works fine in ubuntu but on a 'osx lion' sort dosen't have the --random-sort option.
I don't want to... (5 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)
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)
Please suggest a sort command to achieve the below task. Thanks.
I want to sort a file considering multiple keys.
Sort Keys: Field 2, Field4 and Field6
Input file
vqrs,16,zzz,1235,eq,T
abcd,11,zzz,1234,pq,F
abcd,10,zzz,1235,pq,F
lqrs,15,zzz,1235,eq,T
pqrs,12,zzz,1234,eq,F... (3 Replies)
Discussion started by: pretty1234
3 Replies
LEARN ABOUT DEBIAN
cz::sort
Cz::Sort(3pm) User Contributed Perl Documentation Cz::Sort(3pm)NAME
Cz::Sort - Czech sort
SYNOPSIS
use Cz::Sort;
my $result = czcmp("_x j&a", "_&p");
my @sorted = czsort qw(plachta plaoka Planieka planieka plani);
print "@sorted
";
DESCRIPTION
Implements czech sorting conventions, indepentent on current locales in effect, which are often bad. Does the four-pass sort. The idea and
the base of the conversion table comes from Petr Olsak's program csr and the code is as compliant with CSN 97 6030 as possible.
The basic function provided by this module, is czcmp. If compares two scalars and returns the (-1, 0, 1) result. The function can be called
directly, like
my $result = czcmp("_x j&a", "_&p");
But for convenience and also because of compatibility with older versions, there is a function czsort. It works on list of strings and
returns that list, hmm, sorted. The function is defined simply like
sub czsort
{ sort { czcmp($a, $b); } @_; }
standard use of user's function in sort. Hashes would be simply sorted
@sorted = sort { czcmp($hash{$a}, $hash{$b}) }
keys %hash;
Both czcmp and czsort are exported into caller's namespace by default, as well as cscmp and cssort that are just aliases.
This module comes with encoding table prepared for ISO-8859-2 (Latin-2) encoding. If your data come in different one, you might want to
check the module Cstocs which can be used for reencoding of the list's data prior to calling czsort, or reencode this module to fit your
needs.
VERSION
0.68
SEE ALSO perl(1), Cz::Cstocs(3).
AUTHOR
(c) 1997--2000 Jan Pazdziora <adelton@fi.muni.cz>, http://www.fi.muni.cz/~adelton/
at Faculty of Informatics, Masaryk University, Brno
perl v5.10.1 2000-05-16 Cz::Sort(3pm)