02-13-2008
Sorting Question
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 recieves as input a csv file, removes the first line of the file and calculates the number of sessions instances per hour
#Enjoy :-)
#deleting the statistics file and file with no first line from the system
rm -rf /tmp/scripts/stat_file
rm -rf /tmp/scripts/New_File_Name
#Inputing the File name to be analyzed
read -p "Enter The File Name to Analyze -> " File_Name
#Removing the first line which contains the field names
tail +2 $File_Name > /tmp/scripts/New_File_Name
#printing the time field from the csv file, printing just the hour, counting instances of each hour and redirecting to a statistics file
awk -F ',' '{ print $4 }' /tmp/scripts/New_File_Name | awk -F ':' '{ print $1 }' | uniq -c >> /tmp/scripts/stat_file
#printing the first and second field from the output file with explanations.
awk '{ print "there were "$1" sessions at "$2" AM" }' /tmp/scripts/stat_file
now, I want to add the dates also. date is field $3 in the original file and is in dd-mm-yy format.
I'm stuck :-(
Any ideas?
thanks in advance
The owl
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,
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... (4 Replies)
Discussion started by: mashy
4 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
LAST(1) BSD General Commands Manual LAST(1)
NAME
last -- indicate last logins of users and ttys
SYNOPSIS
last [-n] [-h host] [-t tty] [user ...]
DESCRIPTION
Last will list the sessions of specified users, ttys, and hosts, in reverse time order. Each line of output contains the user name, the tty
from which the session was conducted, any hostname, the start and stop times for the session, and the duration of the session. If the ses-
sion is still continuing or was cut short by a crash or shutdown, last will so indicate.
-n Limits the report to n lines.
-h host Host names may be names or internet numbers.
-t tty Specify the tty. Tty names may be given fully or abbreviated, for example, ``last -t 03'' is equivalent to ``last -t tty03''.
If multiple arguments are given, the information which applies to any of the arguments is printed, e.g., ``last root -t console'' would list
all of ``root's'' sessions as well as all sessions on the console terminal. If no users, hostnames or terminals are specified, last prints a
record of all logins and logouts.
The pseudo-user reboot logs in at reboots of the system, thus ``last reboot'' will give an indication of mean time between reboot.
If last is interrupted, it indicates to what date the search has progressed. If interrupted with a quit signal last indicates how far the
search has progressed and then continues.
SEE ALSO
lastcomm(1), utmpx(5), ac(8)
HISTORY
Last appeared in 3.0BSD.
4th Berkeley Distribution June 6, 1993 4th Berkeley Distribution