07-13-2007
sort / cut question
Hi All,
I have a small problem, hope you can help me out here.
I have a file that contains the same format of lines in 99% of the cases.
906516 XYZ.NNN V 0000 20070711164648 userID1 userID2 hostname 20070711164641
There are unfortunately several lines with these format:
906516 XYZ V 0000 20070711164647 userID1 userID2 hostname 20070711164641
The difference is in the 2nd coloumn. Sometimes its length is 3 , sometimes 7 digits long. Thus the number of delimiters between 2nd and 3rd column are also varied. Imagine the two lines as "V" in coloumn 3 would be in the same line...
My scenario is:
cut out the 1st(the number) and 5th (timestamp) coloumn and sort the result in reverse order using the timestamp column as key.
My command is:
cat filename |cut -f 1,15 -d " " |sort -r -k 2,2
Obviously this cannot work properly because sometimes the 5th column does not start at the 15th " " delimiter due the above mentioned reasons.
Could you guys let me know a solution I can carry out this scenario? I checked man for cut but could not find an option of using sophisticated delimiters, etc...
Thanks a lot!
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
LEARN ABOUT DEBIAN
mrtg-logfile
MRTG-LOGFILE(1) mrtg MRTG-LOGFILE(1)
NAME
mrtg-logfile - description of the mrtg-2 logfile format
SYNOPSIS
This document provides a description of the contents of the mrtg-2 logfile.
OVERVIEW
The logfile consists of two main sections.
The first Line
It stores the traffic counters from the most recent run of mrtg.
The rest of the File
Stores past traffic rate averates and maxima at increassing intervals.
The first number on each line is a unix time stamp. It represents the number of seconds since 1970.
DETAILS
The first Line
The first line has 3 numbers which are:
A (1st column)
A timestamp of when MRTG last ran for this interface. The timestamp is the number of non-skip seconds passed since the standard UNIX
"epoch" of midnight on 1st of January 1970 GMT.
B (2nd column)
The "incoming bytes counter" value.
C (3rd column)
The "outgoing bytes counter" value.
The rest of the File
The second and remaining lines of the file contains 5 numbers which are:
A (1st column)
The Unix timestamp for the point in time the data on this line is relevant. Note that the interval between timestamps increases as you
progress through the file. At first it is 5 minutes and at the end it is one day between two lines.
This timestamp may be converted in OpenOffice Calc or MS Excel by using the following formula
=(x+y)/86400+DATE(1970;1;1)
(instead of ";" it may be that you have to use "," this depends on the context and your locale settings)
you can also ask perl to help by typing
perl -e 'print scalar localtime(x),"
"'
x is the unix timestamp and y is the offset in seconds from UTC. (Perl knows y).
B (2nd column)
The average incoming transfer rate in bytes per second. This is valid for the time between the A value of the current line and the A
value of the previous line.
C (3rd column)
The average outgoing transfer rate in bytes per second since the previous measurement.
D (4th column)
The maximum incoming transfer rate in bytes per second for the current interval. This is calculated from all the updates which have
occured in the current interval. If the current interval is 1 hour, and updates have occured every 5 minutes, it will be the biggest 5
minute transfer rate seen during the hour.
E (5th column)
The maximum outgoing transfer rate in bytes per second for the current interval.
AUTHOR
Butch Kemper <kemper@bihs.net> and Tobias Oetiker <tobi@oetiker.ch>
2.17.4 2012-01-12 MRTG-LOGFILE(1)