I would like to use awk to parse a file with three columns in, like:
they represent the Circle the hour and the number of transactions.
There are thousand of lines, I would like to generate a single table
with hours as headers, the row name will be the Circle name, and the cells will be the sum of number of transaction for that Circle name
in that particular hour like:
I only have access to the standard AWK as operating system HP-UX, no gawk ....
Thanks.
Last edited by radoulov; 03-06-2011 at 01:39 PM..
Reason: Code tags, please!
Dear Folks,
If I have 2 files, say A and B in format:
A:
$1 $2
01032 12856
01041 13351
01042 11071
01042 12854
01042 12862
01042 12866
.
.
.
and
B: (2 Replies)
Hello everyone,
I would like to use awk to parse a file with three columns in, like:
monday 0 1
monday 1 1
monday 2 1
monday 3 1
monday 4 1
monday 5 1
tuesday 0 5
tuesday 1 1
tuesday 2 1
tuesday 3 1
tuesday 4 1
wednesday 0 1
monday 5 25
they represent the day the hour and the... (2 Replies)
Hi
I want create table based on csv file .I have come up with some informations getting columns names and then no idea from that
.Please any help
file.txt
col1|col2|col3|col4|col5
1234|zxxxx|xcvvv|300|null
file.sh
file=$1
c1=`head -1 $file|tr "|" "\n" |cat -n`
echo "$c1"... (31 Replies)
I need to create a simple table of information by grepping several columns from various files and display them all at once with simple headers on top. Can anyone help get me started? I am very new to unix so I really have no idea how to work with this and I appreciate any help I can get! Let me... (11 Replies)
hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname'
for example
... (6 Replies)
Hi,
Can anyone tell me that, How to create table in Oracle database through shell script(ksh).
Table contains 3 fields,
1] Emp ID, String, primary key
2] Name, String
3] B Date, date.
Thanks in advance. (6 Replies)
Hello,
Could you please let me know the correct format of CREATE TABLE statement with DATE format.
CREATE TABLE EMP_TABLE1 (
NAME VARCHAR(6) PRIMARY KEY,
ADDRESS VARCHAR(6),
BIRTH_DATE DATE
);
I want BIRTH_DATE to be in "YYYYMMDDHHMISS" format.
How we can create table with... (4 Replies)
I have a table ABC with 4 columns and below data
Col1,Col2,Col3,Col4
prod,10,12,joba
prod,10,11,jobb
qa,10,12,jobc
I want to create an output file like this
Server:prod
StartTime:10
EndTime:12
JobName:joba
Server:prod
StartTime:10
EndTime:11
JobName:jobb (3 Replies)
Gents,
Can you please help me to create a pivot table from a csv file. ( I have zip the csv file)
Using the file attached, columns 1,28 and 21 i would like to get something like this output
JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total... (4 Replies)
Hi everyone,
Has anyone figured out yet how to do pivot table averages using AWK. I didn't see anything with regards to doing averages.
For example, suppose you have the following table with various individuals and their scores in round1 and round2:
SAMPLE SCORE1 SCORE2
British ... (6 Replies)
Discussion started by: Geneanalyst
6 Replies
LEARN ABOUT DEBIAN
lurker-search
LURKER-SEARCH(1) General Commands Manual LURKER-SEARCH(1)NAME
lurker-search -- searches for messages in a lurker database
SYNOPSIS
lurker-search [-c <config-file>] [-k <keyword>] [-d -f -i -v -q] [<terms>*]
DESCRIPTION
lurker-search searches a lurker database the same way as the web interface. It can output summary information and delete messages.
OPTIONS -c config-file
Use this config file for lurker settings.
-k keyword
Tag the matching messages with this keyword.
-d Delete the messages found by this search
-f Don't prompt before deleting
-i Command line paramers are not search terms, but message IDs.
-v Output message summary information
-q Don't output message ids or status
SEARCH TERMS
Lurker-search accepts these keywords for searching:
-xxx select messages which do NOT match this term
id:xxx select a message by the Message-ID field
rt:xxx select messages which reply to the chosen Message-ID
th:xxx select messages included in this thread
ml:xxx select messages in this mailing list
gr:xxx select messages in this mailing list group
au:xxx select messages with this term in the author fields
sb:xxx select messages with this word in the subject
lang:xxx select messages in this language
SEE ALSO lurker-index(1), lurker-prune(1), lurker-params(1), lurker-list(1)
lurker documentation on http://lurker.sourceforge.net/
COPYRIGHT
Copyright (C) 2002: Wesley W. Terpstra <terpstra@users.sourceforge.net>
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; version 2.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
BUGS
Before reporting a bug, please confirm that the bug you found is still present in the latest official release. If the problem persists,
then send mail with instructions describing how to reproduce the bug to <lurker-users@lists.sourceforge.net>.
LURKER-SEARCH(1)