04-04-2008
Post sample of input data
That's because your command is not able to isolate the RspTime numbers from the non-numbers. Formulate your command so that you sort only on the numerical RspTime column instead of the alphanumeric data. Show a sample of the input data file also.
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 REDHAT
tabfunc
TABFUNC(1) General Commands Manual TABFUNC(1)
NAME
tabfunc - convert table to functions for rcalc, etc.
SYNOPSIS
tabfunc [ -i ] func1 [func2 ..]
DESCRIPTION
Tabfunc reads a table of numbers from the standard input and converts it to an expression suitable for icalc(1), rcalc(1) and their
cousins. The input must consist of a M x N matrix of real numbers, with exactly one row per line. The number of columns must always be
the same in each line, separated by whitespace and/or commas, with no missing values. The first column is always the independent variable,
whose value indexes all of the other elements. This value does not need to be evenly spaced, but it must be either monotonically increas-
ing or monotonically decreasing. (I.e. it cannot go up and then down, or down and then up.) Maximum input line width is 4096 characters
and the maximum number of data rows is 1024. Input lines not beginning with a numerical value will be silently ignored.
The command-line arguments given to tabfunc are the names to be assigned to each column. Tabfunc then produces a single function for each
column given. If there are some columns which should be skipped, the dummy name "0" may be given instead of a valid identifier. (It is
not necessary to specify a dummy name for extra columns at the end of the matrix.)
The -i option causes tabfunc to produce a description that will interpolate values in between those given for the independent variable on
the input.
EXAMPLE
To convert a small data table and feed it to rcalc for some calculation:
rcalc -e `tabfunc f1 f2 < table.dat` -f com.cal
AUTHOR
Greg Ward
SEE ALSO
cnt(1), icalc(1), neaten(1), rcalc(1), rlam(1), total(1)
RADIANCE
10/8/97 TABFUNC(1)