Sponsored Content
Full Discussion: Sorting Question
Top Forums Shell Programming and Scripting Sorting Question Post 302167042 by The Owl on Wednesday 13th of February 2008 10:07:48 AM
Old 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

Noob sorting question

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

sorting question

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

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... (4 Replies)
Discussion started by: mashy
4 Replies

4. UNIX for Dummies Questions & Answers

Sorting question

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

Sorting help

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

HELP on sorting

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

Sorting HELP

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

sorting

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

Quick Question: Sorting

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

Question about sorting -- how to pass an array to a function

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
All times are GMT -4. The time now is 12:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy