07-13-2007
Thank you!
Now I have a file with the content like this:
20070711172841 905994
20070711172822 905994
20070711171431 906608
20070711171412 906608
20070711171142 905994
20070711171140 905994
20070711171139 905994
20070711164813 905994
I would like to keep only one line where the second column is the same. But that line should be the most lastest entry (timestamp in 1st coloumn).
I tried command:
sort -u -k 2,2
but this keeps the oldest timestamp
I tought that -u suppress everything but the first match. The first match (that should be kept) should be :
20070711172841 905994
but my command magically keeps the oldest line:
20070711164813 905994
Could you please advise on why -u does not work as anticipated?
Thank you!
BearCheese
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Using the last, uniq, sort and cut commands, determine how many times the different users have logged in.
I know how to use the last command and cut command...
i came up with last | cut -f1 -d" " | uniq
i dont know if this is right, can someone please help me... thanks (1 Reply)
Discussion started by: jay1228
1 Replies
2. Shell Programming and Scripting
how to cut for pattern in the file and then count each occurance?
say, each line has unique pattern and u want to grep but at last, you want to see how many of them occur?
say,
cut -d'\" -f15 filename | sort -? or.. do i need to use sed or something..
i need to count lets say
how... (5 Replies)
Discussion started by: hankooknara
5 Replies
3. UNIX for Dummies Questions & Answers
#!/bin/bash
echo "UserName PID Command"
ps -ef > ps.temp
grep '^\{2,3\}\{4\}' ps.temp > ps.temp2
cut -f1,2,8 ps.temp2
rm ps.temp*
I am having some problems with the cut command. I only want to display the UID (field 1), PID(field 2), and Command(field 8). Right now the whole ps -ef... (5 Replies)
Discussion started by: knc9233
5 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have created a variable abc within my script which can have values as follows
abc = Ram,Iam
or it can be
abc = Uam
or it can be
abc = Sam,Tam,Pam
Basically it can have a max of 3 values , seperated by comma.
I want to assign these 3 values to 3 different variables
In case of... (2 Replies)
Discussion started by: samit_9999
2 Replies
5. Solaris
I have the following requirement.
1. I have to concatenate the 10 fixed width files.
2. sort based on first 10 characters
3. after that i have remove first 10 chacters from the file.
can you please tell me how to do it.
Thanks in Advance
Samba (1 Reply)
Discussion started by: samba
1 Replies
6. UNIX for Dummies Questions & Answers
Hello,
I am trying, utilizing the few commands I know, to extract all records within my file that were generated in November of 2007. Each record within the file has a "date" field giving the month, day, and year (9-8-88). How do I extract those records to their own file?
Once I extract... (4 Replies)
Discussion started by: babbabooey
4 Replies
7. Homework & Coursework Questions
<B>andan100:Anders:Andersson:800101-1234:TNCCC_1:TDDB46 TDDB80:berbe101:Bertil:Bertilsson:800102-1234:TNCCC_1:TDDB46 TDDB80:The top is how it looks right now I want it t look
like this under and I want it to be sorted. I have tried with cut -f -d studenter.txt and so on but it still doesnt work... (2 Replies)
Discussion started by: aannaann
2 Replies
8. Shell Programming and Scripting
I have a file and need to only select users that have a shell of “/bin/bash” in the line using awk or sed please help (4 Replies)
Discussion started by: boyboy1212
4 Replies
9. UNIX for Advanced & Expert Users
Please help.
I have a file containing rows of information. The row needs to be broken down into blocks of 5 and then sorted.
Example:
10381
1042010046 ... (4 Replies)
Discussion started by: Dolph
4 Replies
10. UNIX for Dummies Questions & Answers
Korn Shell
I have a file whose values are delimited using colon ( : )
$ cat test.txt
hello:myde:temp:stiker
$ cut -d: -f2,4 test.txt
myde:stikerI want field 2 and field 4 to be returned but separated by a hyphen. The output should look like
myde-stiker
How can do this ? (without awk... (11 Replies)
Discussion started by: kraljic
11 Replies
look(1) General Commands Manual look(1)
NAME
look - Finds lines in a sorted list
SYNOPSIS
look [-df] [-tcharacter] string [file]
The look command prints all lines in a sorted file that begin with string.
OPTIONS
Uses dictionary order; only letters, digits, tabs, and spaces are used in comparisons. Searches without regard to case; treats uppercase
and lowercase as equivalent. Ignores character and characters following it in the search string. If you specify look -tC ABCDE, the
string ABCDE would become (in effect) AB, with CDE being ignored. This option is primarily for shell scripts, in which more than one
string is being processed.
DESCRIPTION
If no file is specified, look searches in the system word list /usr/share/dict/words, with the options -df assumed by default.
The look command uses binary search.
The -d and -f options affect comparisons as in sort.
NOTES
In order to use the -f option, you must first sort file with the sort -f command; otherwise, look displays only lowercase items.
If you do not specify -f, but specify a file (such as /usr/share/dict/words) that has been sorted with sort -f, look may not produce any
output.
EXAMPLES
To search a sorted file called sortfile for all lines that begin with the string as, enter: look as sortfile To search the system word list
for all words beginning with smi, enter: look smi
This might result in: smile smirk smith smithereens Smithfield Smithson smithy smitten
FILES
System word list.
SEE ALSO
Commands: grep(1), sort(1), spell(1)
look(1)