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
LEARN ABOUT MOJAVE
faxcron
FAXCRON(8) System Manager's Manual FAXCRON(8)
NAME
faxcron - HylaFAX routine maintenance script
SYNOPSIS
/usr/sbin/faxcron [ -n ] [ -l lastrun ]
DESCRIPTION
faxcron is a command script that does routine upkeep tasks in a HylaFAX spooling directory hierarchy. This script is intended to be
invoked from cron(8) on behalf of the fax user (often the ``fax'' user is uucp) once a day, with the standard output sent by mail to the
HylaFAX administrator. For example, the following crontab might be set up for the fax user:
25 23 * * * sh /usr/sbin/faxcron | mail FaxMaster
The faxcron script does the following work:
o report statistics for facsimile transmitted since the last time faxcron was run.
o report statistics for facsimile transmitted in the past week.
o report statistics for facsimile received since the last time faxcron was run.
o report statistics for facsimile received in the past week.
o report any recent calls that failed suspiciously and return the associated trace log;
o purge data that is 30 days or older from the remote machine information directory;
o delete information that is 30 days or older from session trace log files;
o remove files from the tmp directory that are older than 1 day;
o remove files in the received facsimile queue that are 7 days or older;
o report sites that are currently having jobs rejected; and
o force all session log files to be owned by the fax user and kept with protection mode 644.
OPTIONS
-n Forces faxcron to run without updating any files.
-l lastrun
Forces the notion of the last time that faxcron was run to be lastrun. The value of lastrun is a date and time string of the
form ``MM/DD/YY HH:MM'' (the date(1) format string ``%D %H:%M'').
-info n Set the expiration time for data in the info database to be n days.
-log n Set the expiration time for session log data to be n days.
-rcv n Set the expiration time for files in the received facsimile queue to be n days.
-tmp n Set the expiration time for files in the tmp directory to be n days.
-mode m Set the file protection mode for session logs to m (a command line argument to chmod(1)).
NOTES
This script requires nawk(1) or gawk(1) and a date (1) program that supports the ``+format'' option.
If session logs are to be kept private this script must be modified to filter out sensitive information such as calling card numbers. (It
should also be run with ``-mode 0600'' so that session log files are not publicly readable.)
FILES
/var/spool/hylafax spooling area
/var/spool/hylafax/status/lastrun timestamp of last run
/usr/sbin/xferfaxstats for generating transmit statistics
/usr/sbin/recvstats for generating receive statistics
/var/spool/hylafax/tmp/faxcronXXXX temporary file for truncating session logs
/var/spool/hylafax/tmp/faxlogXXXX temporary file for logs of failed calls
SEE ALSO
cron(8), faxq(8), faxgetty(8), faxsend(8), xferfaxstats(8), recvstats(8), hylafax-server(5)
May 12, 1996 FAXCRON(8)