08-19-2011
Hi.
Quote:
msort is a program for sorting files in sophisticated ways. It was originally developed for alphabetizing dictionaries of "exotic" languages in formats like those used by Shoebox and Toolbox, for which it has been extensively used, but is useful for many other purposes. msort differs from typical sort utilities in providing greater flexibility in parsing the input into records and identifying key fields and greater control over the sort order.
...
Msort stores numeric keys internally as double precision floating point numbers.
The conversion is done using the standard C library function strtod(3), which under-
stands both standard and scientific notation, decimal and hexadecimal. The special
values INFINITY and NAN are also supported. For details, see the documentation
for strtod(3). The interpretation of strings as numbers is governed by the locale
setting. Numbers containing delimiters such as commas can be sorted numerically
by using msort's exclusion facilities to remove the delimiters.
from the extensive pdf describing msort
The utility
msort might be found in your repository, or, failing that, at
MSORT
Best wishes ... cheers, drl
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i have been trying to understand this chapter titled "Searching for Files and Text" for a few weeks now.
unfortunately, this chapter is one of those things, that no matter how hard you try and how long you try for, you are incapable of understanding (at least in my case)
this entire chapter,... (2 Replies)
Discussion started by: xyyz
2 Replies
2. UNIX for Dummies Questions & Answers
It seems our administrators had installed the version of the "sort" command not having the -M option. Does anyone have the source code for this routine?
I need to be able to sort on month comparison:
e.g. "sudo at -l | sort -k3M,5" (1 Reply)
Discussion started by: superdelic
1 Replies
3. Solaris
Hello experts,
I am using SunFire T200.
When I start reading the mail with "mail" command it comes older mail first.
From MAILER-DAEMON Sat Mar 28 06:02:48 2009
Return-Path: <MAILER-DAEMON@emarn1>
Received: from localhost (localhost)
....
....
I want to see the most recent mail... (1 Reply)
Discussion started by: thepurple
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: daniel.gbaena
7 Replies
5. Shell Programming and Scripting
I need to sort the following file by the rhdiskpower devices in the last column:
Total_MB Free_MB OS_MB Name Failgroup Library Label UDID Product Redund Path
1024 851 1024 OCRVOT1_0000 OCRVOT1_0000 System UNKNOWN ... (3 Replies)
Discussion started by: wjssj
3 Replies
6. Shell Programming and Scripting
hi,
please can I ask you for some help? I have data from 3D situation, x y z value
I'd like to use gnuplot to generate maps of the value in the planes z=0 to z=1 for example, my file looks
like
-0,012 0,0060 0,0 0,13972813076023477
-0,012 0,0064319163 4,2894483E-4 ... (1 Reply)
Discussion started by: kocour
1 Replies
7. UNIX for Dummies Questions & Answers
I am going through the Unix Made Easy second edition book by John Muster. So far it's been very informative and I can tell it may be a bit out of date.
In one of the exercises it talks about the "sort" command and using it to sort column's of data etc. The "sort" command has changed a bit and... (1 Reply)
Discussion started by: budfoxcat
1 Replies
8. UNIX for Dummies Questions & Answers
I have a group of files that I need to be sorted by number. I have tried to use the sort command without any luck.
ls includes*
includes1
includes10
includes11
includes12
includes2
includes3
includes4
includes5
includes6
includes7
includes8
includes9
I have tried ls includes*... (6 Replies)
Discussion started by: newbie2010
6 Replies
9. UNIX for Beginners Questions & Answers
Hi All,
I have 2 pipe delimited files viz., file_old and file_new. I'm trying to compare these 2 files, and extract all the different rows between them into a new_file.
comm -3 < sort file_old < sort file_new > new_file
I am getting the below error:
-ksh: sort: cannot open
But if I do... (7 Replies)
Discussion started by: njny
7 Replies
10. UNIX for Beginners Questions & Answers
Hi,
PROCINFO seems to be a great function but I don't manage to make it works.
input:
B,A,C
B
B,B
As an example, just want to count the occurence of each letter across the input and sort them by decreased order.
Wanted output:
B 4
A 1
C 1
When I use this command, the PROCINFO... (4 Replies)
Discussion started by: beca123456
4 Replies
strtod(3C) Standard C Library Functions strtod(3C)
NAME
strtod, strtof, strtold, atof - convert string to floating-point number
SYNOPSIS
#include <stdlib.h>
double strtod(const char *restrict nptr, char **restrict endptr);
float strtof(const char *restrict nptr, char **restrict endptr);
long double strtold(const char *restrict nptr, char **restrict endptr);
double atof(const char *str);
DESCRIPTION
The strtod(), strtof(), and strtold() functions convert the initial portion of the string pointed to by nptr to double, float, and long
double representation, respectively. First they decompose the input string into three parts:
1. An initial, possibly empty, sequence of white-space characters (as specified by isspace(3C))
2. A subject sequence interpreted as a floating-point constant or representing infinity or NaN
3. A final string of one or more unrecognized characters, including the terminating null byte of the input string.
Then they attempt to convert the subject sequence to a floating-point number, and return the result.
The expected form of the subject sequence is an optional plus or minus sign, then one of the following:
o A non-empty sequence of digits optionally containing a radix character, then an optional exponent part
o A 0x or 0X, then a non-empty sequence of hexadecimal digits optionally containing a radix character, then an optional binary exponent
part
o One of INF or INFINITY, ignoring case
o One of NAN or NAN(n-char-sequenceopt), ignoring case in the NAN part, where:
n-char-sequence:
digit
nondigit
n-char-sequence digit
n-char-sequence nondigit
In default mode for strtod(), only decimal, INF/INFINITY, and NAN/NAN(n-char-sequence) forms are recognized. In C99/SUSv3 mode, hexadecimal
strings are also recognized.
In default mode for strtod(), the n-char-sequence in the NAN(n-char-equence) form can contain any character except ')' (right parenthesis)
or '