07-06-2011
How to sort a column based on numerical ascending order if it includes e-10?
I have a column of numbers in the following format:
1.722e-05
2.018e-05
2.548e-05
2.747e-05
7.897e-05
4.016e-05
4.613e-05
4.613e-05
5.151e-05
5.151e-05
5.151e-05
6.1e-05
6.254e-05
7.04e-05
7.12e-05
7.12e-05
I want to sort it in numerical ascending order but the e-'s complicate things. How do I go about doing this? Thanks!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
What's the command to sort a file in ascending order and redirect the output to another file?
Thanks!!!!!! (1 Reply)
Discussion started by: gyik
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I need to sort it by column or need it in a specific order...
input is
=====
uid=shashi country= india region =0 ph=0
uid= jon region= asia ph= 12345 country=0
uid = man country= india ph=2222 region=0
uid= neera region= asia ph= 125 country=0
output should be
uid=shashi ... (1 Reply)
Discussion started by: hegdeshashi
1 Replies
3. Linux
HI everyone,
I am trying to use the unix sort command to get a list of numbers sorted in ascending order but having trouble in getting it to work.
An example of this issue would be when i am trying to sort the following three
number each on a different line "1" , "2" and "116" the sort command... (3 Replies)
Discussion started by: wali4813
3 Replies
4. Shell Programming and Scripting
I have a FILE1.DAT with the following information
21111111110001343 000001004OLF-AA029100020091112
21111111110000060 000001004ODL-CH001000020091112
24444444440001416 000001045OLF-AA011800020091112
23333333330001695 000001039OLF-AA030600020091112
23333333330000111... (5 Replies)
Discussion started by: new2ksh
5 Replies
5. Shell Programming and Scripting
My input file:
Class
Number Position Range
1 Initial 50
1 Initial 50
2 Terminal 150
2 Terminal 20
2 Single 10
3 Single 20
4 Double 50
5 Initial 50
5 Initial 60
Class
Number... (11 Replies)
Discussion started by: patrick87
11 Replies
6. Shell Programming and Scripting
Input file
9.99331e-13
8.98451e-65
9.98418e-34
7.98319e-08
365592
111669
74942.9
0
Desired output
365592
111669
74942.9
7.98319e-08
1.99331e-13
6.98418e-34 (2 Replies)
Discussion started by: perl_beginner
2 Replies
7. UNIX for Dummies Questions & Answers
I have a text file where the second column is a list of numbers going from small to large. I want to extract the rows where the second column is smaller than or equal to 0.0001.
My input:
rs10082730 9e-08 12 46002702
rs2544081 1e-07 12 46015487
rs1425136 1e-06 7 35396742
rs2712590... (1 Reply)
Discussion started by: evelibertine
1 Replies
8. UNIX for Dummies Questions & Answers
I have a text file where I want to append a column of numbers in ascending orders.
Input:
57 abc
25 def
32 ghi
54 jkl
Output:57 abc
57 abc 1
25 def 2
32 ghi 3
54 jkl 4
How do I go about doing that? Thanks! (11 Replies)
Discussion started by: evelibertine
11 Replies
9. Shell Programming and Scripting
Hi,
i had a data block (coming from pipe from other codes) as:
H YF_CO.dat 77164 11/17/2013 04:00:02 731374590.96 1 1 731374590.96 76586 77164 578 2988 Y
H YF_CO.dat 77164 11/17/2013 04:00:07 731374590.96 1 4 731374590.96 76586 77164 578 2988 Y
H YF_CO.dat 77178 ... (5 Replies)
Discussion started by: pr5439
5 Replies
10. Shell Programming and Scripting
How to sort the following output based on lowest to highest BE?
The following sort does not work.
$ sort -t. -k1,1n -k2,2n bfd.txt
BE31.116 0s 0s DOWN DAMP
BE31.116 0s 0s DOWN DAMP
BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies
evmsort(1) General Commands Manual evmsort(1)
NAME
evmsort - sort events
SYNOPSIS
show_template]] sport_spec] [filename |
DESCRIPTION
The command reads and sorts a stream of EVM events. By default, events are read from and are sorted into ascending timestamp order.
Sorted events are written to the command's stream in the form of raw EVM events.
The sort order can be specified by supplying a sort_spec, either through the option or by setting the environment variable to the required
specification. The specification is a character string of the form:
key_item[
The key_item is the name of any EVM standard data item and the character is optional.
If the special key_item is specified, the event's data item is expanded as described in the evmshow(1) manpage, and the resulting string is
used as the sort key.
The optional trailing or character indicates ascending or descending sort. By default, items are sorted in ascending order.
Multiple items in the string are separated by colon characters The left-most key_item in the specification is the most significant key.
If a key_item that is included in the sort specification is not present in an event read from the input stream, the item is considered to
have a low value for that event. For example, if input events are being sorted in ascending order according to their data items, and one
event does not contain a name, that event appears first in the output stream.
If the option is specified, automatically starts and pipes the sorted event stream into it, producing a sorted and formatted display of
events. If a argument is also specified with the specified template string is passed to through its own option.
See the evmshow(1) manpage for more information.
Options
Automatically starts
to produce a formatted display of the sorted events.
The specification to be used in sorting events.
See the section for the syntax of the sort_spec, and for details of the default sort order.
Template string to be passed to
if the option is also specified. If the option is not specified, this argument is ignored. See the evmshow(1) manpage for a
description of the template string.
Operands
filename Reads event sources from filename. If filename is omitted, or is specified as event sources are read from
EXTERNAL INFLUENCES
Environment Variables
The following environment variables affect the execution of
This variable contains a string formatted as described for a
sort_spec. If the option is omitted, the string is used as the sort_spec.
RETURN VALUES
The following exit values are returned:
Successful completion.
An error occurred.
EXAMPLES
o The following example retrieves all events with a priority of 300 or greater, sorts them into descending order of priority (most urgent
event first) and then ascending order of time (oldest event first), and automatically runs to display them.
o The following example yields a list of all events, sorted with the latest event first within
o The following example yields a list of all events, sorted first in order of their formatted messages and then sorted in ascending order
of time. Events are passed to for display and subsequently to the command for viewing.
WARNINGS
The command rejects attempts to output raw events to a terminal device.
SEE ALSO
Commands
evmget(1), evmpost(1), evmshow(1), evmwatch(1).
Files
evmchannel.conf(4).
Event Management
EVM(5).
EVM Events
EvmEvent(5).
Event Filter
EvmFilter(5).
evmsort(1)