08-17-2009
sorting question......
HI,
I have been racking my brain for a while on this..... was hoping one of the guru's could point me in the right direction....
Basically I have the following data in a file :
----
2009-01-01 10665 Begin 02:25:23
2009-01-02 10665 Begin 20:54:11
2009-01-03 10665 Begin 05:31:17
2009-01-03 10666 Begin 06:01:38
2009-01-03 10667 Begin 06:33:18
2009-01-03 10668 Begin 07:00:42
2009-01-03 10669 Begin 07:28:14
2009-01-03 10670 Begin 07:56:09
2009-01-06 10671 Begin 00:25:31
2009-01-06 10671 Begin 02:17:50
2009-01-06 10671 Begin 03:55:32
----
I want to end up with :
------
2009-01-02 10665 Begin 20:54:11
2009-01-03 10666 Begin 06:01:38
2009-01-03 10667 Begin 06:33:18
2009-01-03 10668 Begin 07:00:42
2009-01-03 10669 Begin 07:28:14
2009-01-03 10670 Begin 07:56:09
2009-01-06 10671 Begin 03:55:32
-------
I have tried using sort (-u -kn) and in reverse. but either way I do it I always end up getting the first instance of sort on column 2.
e.g. I get
2009-01-06 10671 Begin 00:25:31
instead of :
2009-01-06 10671 Begin 03:55:32
I used : sort -k 1.12,1.16 -u n.out so far ~(nearest try)
I hope someone could help
Many thanks in advance
Raj
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Ok here is the deal, I have a command given to me by some systems guy who I cannot get ahold of on the weekend without paying him alot of money to help me. I need to get this done before Monday as I am just getting pummeled by DOS attacks. The comand given was....
netstat -ntu | awk '{print... (1 Reply)
Discussion started by: Hexabah
1 Replies
2. UNIX for Dummies Questions & Answers
How can I sort lines in a file in a consistent, user-defined way that is not alphabetical, numeric, or patterned in any other way (e.g., sort a bunch of 5 line files to always print lines 2,5,3,4,1)? Thanks in advance. (4 Replies)
Discussion started by: darwin_886
4 Replies
3. Shell Programming and Scripting
Hi All
I have a CSV file where 3rd and 4th fields are date and time
it's a session log file printing the date and time per session
Now, I want to create a statistics of how many sessions per date and Time
I managed a script for sessions per hour
Code:
#!/bin/bash
#This Shell Script... (3 Replies)
Discussion started by: The Owl
3 Replies
4. UNIX for Dummies Questions & Answers
i have list of files:
Wang CVPR 09.pdf
Yaacob AFGR 99.pdf
Shi CVPR 04.pdf
.....
how can i sort with single line this directory so the output will be in the next format:
<year>\t<conference/journal>\t<author list> - t is tab
(its sort by the year)
example:
1999 CVIU ... (2 Replies)
Discussion started by: nirnir26
2 Replies
5. UNIX for Dummies Questions & Answers
i have list of files:
Wang De Wong CVPR 09.pdf
Yaacob AFGR 99 Second edition.pdf
Shimon CVPR 01.pdf
Den CCC 97 long one.pdf
Ronald De Bour CSPP 04.pdf
.....
how can i sort this directory so the output will be in the next format:
<year>\t<conference/journal>\t<author list> - t is tab
(its... (1 Reply)
Discussion started by: nirnir26
1 Replies
6. UNIX for Advanced & Expert Users
hi everyone, I am kind of new to this forum. I need help in sorting this data out accordingly, I am actually doing a traceroute application and wants my AS path displayed in front of my address like this;
192.168.1.1 AS28513 AS65534 AS5089 AS5089 .... till the last AS number and if possible... (1 Reply)
Discussion started by: sam127
1 Replies
7. Shell Programming and Scripting
Hi, I have posted related topic but as i continue the research I find more need to sort the data.
AS(2607:f278:4101:11:dead:beef:f00f:f), AS786 AS6453 AS7575 AS7922
AS(2607:f2e0:f:1db::16), AS786 AS3257 AS36252
AS786 AS3257 AS36252
AS(2607:f2f8:1700::2), AS786 AS6939 AS25795 ... (6 Replies)
Discussion started by: sam127
6 Replies
8. Shell Programming and Scripting
Hi all,
Does anyone can help me the following question? I would like to write an AWK script.
In the following input file, each number in "start" is paired with numbers in column "end".
No Start End
A 22,222,33,22,1233,3232,44 555,333,222,55,1235,3235,66... (7 Replies)
Discussion started by: phoeberunner
7 Replies
9. UNIX for Dummies Questions & Answers
Hi fellow linuxers
I have a quick question... I would like to sort the numbers in each line that are within a file, and I want to sort them so that the numbers in each line go from SMALLEST to HIGHEST. For example, my file looks like this:
6 4 2 3 1 5 7 8
15 16 11 13 12 14 20 18 19 17
24 26... (7 Replies)
Discussion started by: lucshi09
7 Replies
10. Shell Programming and Scripting
Hi, guys
I just wanted to sort the elements of an array ascendingly.
I know the following code does work well:
array=(13 435 8 23 100)
for i in {0..4}
do
j=$((i+1))
while ]
do
if } -le ${array} ]]
then :
else
min=${array}
${array}=${array}
${array}=$min
fi... (5 Replies)
Discussion started by: franksunnn
5 Replies
GURU(8) System Manager's Manual GURU(8)
NAME
guru - System administration
SYNOPSIS
guru [ -e program ] [ -f ] [ -p target ]
DESCRIPTION
guru is a sophisticated program synthesis and system maintenance tool developed after midnight in numerous university computing labs. It
is based on the famous LISP Hacker system, used to develop AI programs on TENEX. guru reads a problem description from the standard input.
An innovative and occasionally correct solution is generated and written to the standard output. Typically, guru is invoked repeatedly
until an acceptable solution is generated or the user community has learned to live with the problem.
The bugreport mechanism sometimes invokes guru. In this case guru executes at a priority inversely proportional to the reported urgency of
the bug. Feature enhancements run at high priority whereas critical problems are fixed only when the machine would otherwise be idle.
If the standard input is empty, guru uses its program synthesis capabilities to generate a selection of screen editors, X widgets, compil-
ers, sundry games and the occasional diatribe.
OPTIONS
-e program
New features are added to an existing program. This option should be used with caution as the enhanced program may behave unpre-
dictably or not at all.
-f Reconstructs filesystems after a crash.
-p target
Ports the entire system on which guru is executing to target, preferably a RISC machine. This is an extremely time consuming oper-
ation and is not guaranteed to terminate.
If more than one option is specified, guru may thrash. Each copy of guru has its own set of unique, additional and undocumented options.
SEE ALSO
YAPS: Yet another Program Synthesiser by S C Johnson.
NOTES
Inherent design limitations prevent guru from synthesising comments. The programs generated are undocumented. The lucidity, politeness,
relevance and language of the occasional diatribe vary considerably.
The only diagnostic is an occasional ``I deserve a raise'' - which may be ignored albeit doing so may provoke ``I resign'' - an unrecover-
able error.
Sending the output of one guru into another can produce quite startling results.
UNIX Programmer's Manual GURU(8)