08-25-2006
Analyze Statistics
I have a file which contains records in the format of
2006-08-25 12:06:13|ABC|93
2006-08-25 12:45:55|ABC|203
2006-08-25 01:48:19|DEF|156
2006-08-25 01:49:09|ABC|12798
2006-08-25 02:49:59|GHL|4109
2006-08-25 03:50:50|DEF|234
where the format is "arrive time"|"message type"|"processing time"
I want to find out
- number of records in the file
=> 6 for above case
- number of records in the file for each message type
=> ABC = 3
DEF = 2
GHL = 1
- distribution of message arrive time
=> 12 - 13 = 2
13 - 14 = 2
14 - 15 = 1
15 - 14 = 1
- average processing time
=> 2932.2
Can anyone helps me with this? THANK YOU!
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello UNIX and Oracle Gurus,
After doing an intensive search from different websites, the UNIX forum I am posting this message seeking help..
I am trying to accomplish the following tasks through the shell script:
1. Rebuild indexes on a Table in Oracle
2. Analyze indexes and table... (0 Replies)
Discussion started by: madhunk
0 Replies
2. What is on Your Mind?
Hi to all of you guys, I'm new here...
May this thread fits on this section. A friend of mine gave me this enigma to do, written in excel. I attach the file below, name New.xls.
Enigma:
There are 10^20 possibilities of tables (Table1, Table 2, Table 3, Table 4, Table 5,...), with ten rows (row... (3 Replies)
Discussion started by: lucky7
3 Replies
3. Solaris
Hi Gurus,
I have installed the stuff needed for patchdiag for patching, its working okay , however after execution of pathcdiag.sparc i am unable to understand the summury which is produced at the end.
Please help !
Thanks (3 Replies)
Discussion started by: kumarmani
3 Replies
4. Solaris
Is there anywhere we can get details about what we should expect to see and not to see in some packets captured with "snoop" during troubleshooting a problem? I know we can capture packes for a failed transaction and compare them with packets for a successful trasaction.Is that the only way to... (4 Replies)
Discussion started by: Pouchie1
4 Replies
5. Cybersecurity
A series on The H about analyzing potentially malicious code flying around on the net. Pretty well written, and a nice read for those interested in how exploits work:
CSI:Internet - Alarm at the pizza service
CSI:Internet - The image of death
CSI:Internet - PDF timebomb
CSI:Internet -... (0 Replies)
Discussion started by: pludi
0 Replies
6. UNIX for Dummies Questions & Answers
What command should I use to analyze file hashing of fixed flat files.
How much work does it take for multiple flat files. (3 Replies)
Discussion started by: jbjoat
3 Replies
7. Programming
Hi, I have two files:
Input_file1.txt
124
235
152
178
156
142
178
163
159
Input_file2.txt
124|5623
452|6698
178|9995
235|7542
159|8852 (1 Reply)
Discussion started by: cpp_beginner
1 Replies
8. UNIX for Dummies Questions & Answers
Hi Dears,
I use the below code to analyze lines in a file:
for line in `cat ucsv`
do
echo $line
//analyze statements
donehowever, if line contains space char, it will be broken. for example, if file content is:
#login,full name,email,project,role,action
gmwen,Bruce... (3 Replies)
Discussion started by: crest.boy
3 Replies
9. Solaris
Hi,
Is there any tool is available for analyzing Oracle X86 snapshot output.
Thanks in advance. (1 Reply)
Discussion started by: sunnybee
1 Replies
LEARN ABOUT DEBIAN
letterize
LETTERIZE(1) Miscellanea LETTERIZE(1)
NAME
letterize_ - phone-number to letter-mnemonic generator
SYNOPSIS
letterize nnnnnnn
DESCRIPTION
This program tries to help you find a letter mnemonic matching a given phone number.
It emits to standard output each possible pronounceable mnemonic, one per line, using the American standard mapping of dial letters to
numbers (2 goes to ABC, 3 to DEF, 4 to GHI, 5 to JKL, 6 to MNO, 7 to PRS, 8 to TUV, 9 to XYZ).
The program uses a table of pronounceable letter-triples derived from a dictionary scan. Each potential mnemonic must be such that all of
its letter-triples are in the table to be emitted. About 30% of possible triples are considered pronounceable.
A typical 7-digit phone number has 19,683 possible mnemonics, but this test usually cuts the list down to a few hundred or so, a reasonable
number to eyeball-check. For some numbers, the list will, sadly, be empty.
It's best to leave out punctuation such as dashes and parens.
BUGS
The filtering method doesn't know what plausible medial triples are not reasonable at the beginnings and ends of words.
I'm not sure what table position 0 (which is what 0 and 1 are mapped to) means. If you figure it out, you tell me. I really should have
generated my own table, but that would have been more work than this seemed worth -- if your number contains either, you probably need to
generate your mnemonic in disjoint pieces around the digits anyway.
AUTHOR
Eric S. Raymond esr@snark.thyrsus.com. It's based on a table of plausible letter-triples that had no name attached to it. Surf to
http://www.catb.org/~esr/ for updates and related resources.
letterize 05/30/2012 LETTERIZE(1)