04-04-2008
Trouble sorting numbers embedded
Hi All,
First time poster.
I have a text file that as many entries like below (single line):
egrep RspTime conlb.txt |more
S(xxx.xxx.xxx.xxx:5050:UP) Hits(13358983, 2/sec, P[12685309, 2/sec]) ATr(2) Mbps(0.07) BWlmt(0 kbits) RspTime(16.50 ms)
...
I am trying to sort on the RspTime from highest to lowest order. When I apply the following command I get a sort where the number start with 9:
suse10x:~ # egrep RspTime conlb.txt | awk '{print $10 $11 " " $1}' | sort -nr |more
RspTime(999.65ms) S(xxx.xxx.xxx.xxx:UP)
RspTime(99.95ms) S(yyy.yyy.yyy.yyy:80:UP)
...<snip>
RspTime(9371.11ms) S(xxx.xxx.xxx.xxx:UP)
RspTime(9345.20ms) S(yyy.yyy.yyy.yyy:80:UP)
RspTime(9319.48ms) S(yyy.yyy.yyy.yyy:80:UP)
There are response times that are much higher than 999.65.
How can I sort this to get the output I am looking for with the highest RspTime ?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have the following output where I need to sort the second column numerically (starting with IBMULT3580-TD10 and ending in IBMULT3580-TD123)
Drv DriveName
0 IBMULT3580-TD13
1 IBMULT3580-TD18
2 IBMULT3580-TD14
3 IBMULT3580-TD10
4 IBMULT3580-TD11
5 IBMULT3580-TD17
... (8 Replies)
Discussion started by: GKnight
8 Replies
2. UNIX for Dummies Questions & Answers
Looking for help for sort, I learned that for sorting numbers I use:
sort -n
but it seems that that is not enough when you have numbers like 0.2000E+7 for example, sort -n will not worry about the E+7 part, and will just sort the numbers like 0.2000.
Exapmle:
cat example.txt
.91000E+07... (9 Replies)
Discussion started by: cosmologist
9 Replies
3. Shell Programming and Scripting
hi all,
i need help on sorting data.
i have a file as below
/home/oracle $ cat 234.txt
+1234
-2356
-1001
+231
0023
-0987
+19000
65487
6
after sorting i want the output as below
-2356
-1001 (2 Replies)
Discussion started by: mahesh1987
2 Replies
4. 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
5. Shell Programming and Scripting
Hello,
I have a file such as this:
chr1
chr2
chr1
chr2
chr3
chr10
chr4
chr5
chrz
chr1AI want to sort it, I use this command:
sort -k1 -th -n testfilebut I get this output, how can I fix this?
chr1
chr1
chr10
chr1A
chr2
chr2 (3 Replies)
Discussion started by: Homa
3 Replies
6. UNIX for Dummies Questions & Answers
sorting
can i do it using simple perl script/awk? (5 Replies)
Discussion started by: sa@@
5 Replies
7. Shell Programming and Scripting
Hi,
I've got two arrays
1 3 5 7
2 4 6 8
and i need to write a shell script to get the output 1 2 3 4 5 6 7 8 without using sort or bubble sort. (1 Reply)
Discussion started by: web2moha
1 Replies
8. Shell Programming and Scripting
Hi Guys,
Would appreciate some help on sorting numbers on a file using the sort command. I have tried this and it's not sorting properly. what am i missing?
cat testing_sort
1:21
4:18
2:17
7:14
9:19
3:12
0:16
8:13
5:20
6:15
10:11
sort -t: -nk1,1 -nk2,2 testing_sort (4 Replies)
Discussion started by: Apollo
4 Replies
9. OS X (Apple)
Hey everybody,
I'm trying to sort scientific numbers in a descending order using the command
sort -gr <file>.
It works fine on a Linux-Server, but doesn't on my macbook pro with OS X 10.10.3 (Yosemite).
I tried to sort the following:
6.38e-10
6.38e-10
1.80e-11
1.00e-10
1.48e-12
And... (9 Replies)
Discussion started by: plebs
9 Replies
10. UNIX for Dummies Questions & Answers
Dear Experts,
I have an IP file which looks like below ----
100 200 5.02
100 200 -2.99
100 200 -3.01
200 300 2.05
200 300 3.01
200 300 -5.06
I want an OP which looks like (decreasing numerically)--
100 200 5.02
100 200 -2.99
100 200 -3.01
200 300 3.01
200 300 2.05
200 300 -5.06 (2 Replies)
Discussion started by: Indra2011
2 Replies
LEARN ABOUT CENTOS
strtok
STRTOK(3) Linux Programmer's Manual STRTOK(3)
NAME
strtok, strtok_r - extract tokens from strings
SYNOPSIS
#include <string.h>
char *strtok(char *str, const char *delim);
char *strtok_r(char *str, const char *delim, char **saveptr);
Feature Test Macro Requirements for glibc (see feature_test_macros(7)):
strtok_r(): _SVID_SOURCE || _BSD_SOURCE || _POSIX_C_SOURCE >= 1 || _XOPEN_SOURCE || _POSIX_SOURCE
DESCRIPTION
The strtok() function breaks a string into a sequence of zero or more nonempty tokens. On the first call to strtok() the string to be
parsed should be specified in str. In each subsequent call that should parse the same string, str must be NULL.
The delim argument specifies a set of bytes that delimit the tokens in the parsed string. The caller may specify different strings in
delim in successive calls that parse the same string.
Each call to strtok() returns a pointer to a null-terminated string containing the next token. This string does not include the delimiting
byte. If no more tokens are found, strtok() returns NULL.
A sequence of calls to strtok() that operate on the same string maintains a pointer that determines the point from which to start searching
for the next token. The first call to strtok() sets this pointer to point to the first byte of the string. The start of the next token is
determined by scanning forward for the next nondelimiter byte in str. If such a byte is found, it is taken as the start of the next token.
If no such byte is found, then there are no more tokens, and strtok() returns NULL. (A string that is empty or that contains only delim-
iters will thus cause strtok() to return NULL on the first call.)
The end of each token is found by scanning forward until either the next delimiter byte is found or until the terminating null byte ('