The fields are: 12-hour format time, some number, state (online, offline) and another number.
What I need to do is a bash script to sort by the last number and also if there are more than 1 same numbers, I want them to be sorted by time (older top and newer as we go down).
My source is already sorted by time but if I sort them by the 5th column with
Code:
sort -k5b
, they come up like this:
Code:
01:49:17 PM 001* OUT 000364
01:52:09 PM 001* ONL 000364
01:10:34 PM 002* ONL 000418
12:48:32 PM 002* OUT 000418
the last two are wrong because 12:48:32 PM is older than 01:10:34 PM.
Hello, I am new in UNIX
I am looking for a instrction to sort a file by columns 6,25 and 41
this is what I tried but not getting the correct result:
sort -t= -k1.6,1.25,1.41 to_sort.txt > sorted.txt
I used -t= just to get the whole line as one field.
INVS80993596SUM994338602XX... (1 Reply)
hello,
i have a table contain many columns delimited by blank.
i want to sort this table by the 2 columns and 3 one and i want to keep the first line inchanged?
how can i do using the sort command?
thanks
table like :
field1 field2 field3 field4
x y z b
t h r n
.. (4 Replies)
Hello all:
i have list with the following format
Id Name Iid Value
0x4440001 customerCode 44077
0x11d2a PrimaryAddress 57.217.41.201
0x129fa ... (15 Replies)
Hope someone can help,
I am trying to sort a generic file like this
test2 A 468 0
test2 R 468 1
test2 E 468 1
test2 R 468 3
test2 R 468 4
test2 R 468 459
test2 Z 468 0
test1 A 191 0
test1 R 191 191
test1 Z 191 0
test3 A 3 0
test3 R 3 3
test3 Z 3 0
test0 A 1 0
test4 A 1 0
test4 E... (2 Replies)
Hi, I am trying to sort a file first by the string column, then by the number column.
file:
xyz1 2
xyzX 4
xyz2 1
xyz13 3
xyz11 5
xyz13 10
xyz1 1
xyz10 1
xyz4 2
result should be
xyz1 1
xyz1 2 ... (3 Replies)
Hi,
A basic query. In the example file below, I want to sort by column 1 and then by column 2 numerically. I have tried sort -k2n,1 file1 but while this sorts the columns in the correct order, it does not sort column 2 numerically. Any help would be much appreciated. Also, if you have time to... (3 Replies)
Howdy!
Need to sort a large .txt file containing the following, using sort. First based on the 1st column, and then on the 2nd column:
Group01.01 1000500 31 0.913 -1.522974494
Group01.01 1001500 16 0.684 -0.967496041
Group01.01 36500 19 0.476 na
Group01.02 365500 15 0.400 na... (1 Reply)
File will have two columns key column and second column which is pipe separated and that need to be sorted.
Below is input file.
1, D|B|A|C
2, C|A|B
3, E|A|F|G|H|D|B|C
4, A|B|D|C|F
Output should be
1, A|B|C|D
2, A|B|C
3, A|B|C|D|E|F|G|H
4, A|B|D|C|F (11 Replies)
hi all,
i have a file , having few columns. i wanted to sort it based on 2nd column and then based on 1st column. But i have some problem in first column.
first column have characters and numbers, but problem is number of characters are not same in all rows. Few rows have 13 characters and then... (3 Replies)
Hi geeks!
I want to convert the following:
EPC-NotificationData: sms:2348034503643
EPC-GroupIds: 300H:10:22-01-2014T07:30:14,22-04-2014T07:30:14
To:
EPC-NotificationData: sms:2348034503643, EPC-GroupIds: 300H:10:22-01-2014T07:30:14,22-04-2014T07:30:14
I want them to be on the same... (13 Replies)
Discussion started by: infinitydon
13 Replies
LEARN ABOUT DEBIAN
nifti_stats
NIFTI_STATS(1) User Commands NIFTI_STATS(1)NAME
nifti_stats - compute NIfTI statistical functions
SYNOPSIS
nifti_stats [-q|-d|-1|-z] value CODE [p1 p2 p3]
DESCRIPTION
nifti_stats supports several distributions (normal, uniform, logistic, chi, etc.) and calculates density or cummulative distribution func-
tion (and many more). Values are printed to stdout and can be piped to other tools.
value can be a single number or in the form bot:top:step.
default ==> output p = Prob(statistic < val).
-q ==> output is 1-p.
-d ==> output is density.
-1 ==> output is x such that Prob(statistic < x) = val.
-z ==> output is z such that Normal cdf(z) = p(val).
-h ==> output is z such that 1/2-Normal cdf(z) = p(val).
Allowable CODEs:
CORREL, TTEST, FTEST, ZSCORE, CHISQ, BETA, BINOM, GAMMA, POISSON, NORMAL, FTEST_NONC, CHISQ_NONC, LOGISTIC, LAPLACE, UNIFORM, TTEST_NONC,
WEIBULL, CHI, INVGAUSS, EXTVAL, PVAL, LOGPVAL and LOG10PVAL
Following CODE are distributional parameters, as needed.
Results are written to stdout, 1 number per output line.
EXAMPLE
Piping output into AFNI program 1dplot:
nifti_stats -d 0:4:.001 INVGAUSS 1 3 | 1dplot -dx 0.001 -stdin
SEE ALSO libnifti(1), nifti_tool(1), nifti1_test(1).
Homepage: http://niftilib.sourceforge.net
AUTHOR
RW Cox - SSCC/NIMH/NIH/DHHS/USA/EARTH - March 2004
This manual page was written by Michael Hanke <michael.hanke@gmail.com>, for the Debian project (but may be used by others).
nifti_stats September 2007 NIFTI_STATS(1)