06-25-2006
Output File
Hi there,
I am having an output file resulting from a script, this output file looks as follow:
10 Account1
20 Account2
89 Account3
Now i have another file which includes all the accounts (i.e. all acounts which have records in the mentioned output file and the rest of acoounts which have no records)...what i want to do is the following:
I want to generate a final out put file which have all the accounts and near to each account it mention the total number of recrods resulted from the above output fle, and if there is any account which have no records in the above output file, then in the final output file the value near to that account shall be 0
Any idea how to do that??
Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies
2. Shell Programming and Scripting
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Discussion started by: adept
4 Replies
3. Shell Programming and Scripting
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies
4. Shell Programming and Scripting
Below script perfectly works, giving below mail output. BUT, I want to make the script mail only if there are any D-Defined/T-Transition/B-Broken State WPARs and also to copy the output generated during monitoring to a temporary log file, which gets cleaned up every week. Need suggestions.
... (4 Replies)
Discussion started by: aix_admin_007
4 Replies
5. Shell Programming and Scripting
Hi All,
I have result log file which looks like this (below): from the content need to consolidate the result and put it in tabular form
1). Intercomponents Checking
Passed: All Server are passed.
======================================================================
2). OS version Checking... (9 Replies)
Discussion started by: Optimus81
9 Replies
6. Red Hat
I ran the following command.
cat abc.c > abc.c
I got message the following message from command cat:
cat: abc.c : input file is same as the output file
How the command came to know of the destination file name as the command is sending output to standard file. (3 Replies)
Discussion started by: ravisingh
3 Replies
7. Shell Programming and Scripting
currently I have process from a raw file to this stage
ALTER TABLE "EXCEL_ADMIN"."TC_TXN_VOID" ADD CONSTRAINT "PK_TC_TXN_VOID" PRIMARY KEY ("TC_TXN_IID")
ALTER TABLE "EXCEL_ADMIN"."TC_TXN_AMT" ADD CONSTRAINT "PK_TC_TXN_AMT" PRIMARY KEY ("TC_TXN_AMT_IID")
ALTER TABLE... (10 Replies)
Discussion started by: jediwannabe
10 Replies
8. Shell Programming and Scripting
Hi Guys,
I want to redirect the output of 3 scripts to a file and then mail the output of those three scripts.
I used below but it is not working:
OFILE=/home/home1/report1
echo "report1 details" > $OFILE
=/home/home1/1.sh > $OFILE
echo... (7 Replies)
Discussion started by: Vivekit82
7 Replies
9. Shell Programming and Scripting
I have a file
# cat /root/llll
11
22
33
44
When I cat this file content to a variable inside a shell script and echo that shell script, it does not show up as separate lines. I need echo output similar to cat.
cat /root/shell_script.sh
#!/bin/bash
var=`cat /root/llll`
echo $var (2 Replies)
Discussion started by: anil510
2 Replies
10. Shell Programming and Scripting
Shell script logic
Hi
I have 2 input files like with file 1 content as (file1)
"BRGTEST-242" a.txt "BRGTEST-240" a.txt "BRGTEST-219" e.txt
File 2 contents as fle(2)
"BRGTEST-244" a.txt "BRGTEST-244" b.txt "BRGTEST-231" c.txt "BRGTEST-231" d.txt "BRGTEST-221" e.txt
I want to get... (22 Replies)
Discussion started by: pottic
22 Replies
acctcms(1M) acctcms(1M)
NAME
acctcms - command summary from per-process accounting records
SYNOPSIS
[options] files
DESCRIPTION
reads one or more files, normally in the form described in acct(4). It adds all records for processes that executed identically-named com-
mands, sorts them, and writes them to the standard output, normally using an internal summary format.
Options
recognizes the following options:
Print output in
ASCII rather than in the internal summary format. The output includes command name, number of times executed, total kcore-
minutes, total CPU minutes, total real minutes, mean size (in K), mean CPU minutes per invocation, ``hog factor'', charac-
ters transferred, and blocks read and written, as in acctcom(1M). Output is normally sorted by total kcore-minutes.
Sort by total
CPU time, rather than total kcore-minutes.
Combine all commands invoked only once under
Sort by number of command invocations.
Any file names encountered hereafter are already in internal summary format.
Process all records as total accounting records.
The default internal summary format splits each field into prime- and non-prime-time parts. This option combines the prime
and non-prime time parts into a single field that is the total of both, and provides upward compatibility with old (i.e.,
UNIX System V) style internal summary format records.
The following options can be used only with the option.
Output a prime-time-only command summary.
Output a non-prime- (offshift) time only command summary.
When and are used together, a combination prime and non-prime time report is produced. All the output summaries are total usage except
number of times executed, CPU minutes, and real minutes which are split into prime and non-prime.
EXAMPLES
A typical sequence for performing daily command accounting and for maintaining a running total is:
WARNINGS
Unpredictable output results if is used on new-style internal-summary-format files, or if it is not used with old style internal summary
format files.
The process mean memory size may overflow for values greater than
SEE ALSO
acct(1M), acctcom(1M), acctcon(1M), acctmerg(1M), acctprc(1M), acctsh(1M), fwtmp(1M), runacct(1M), acct(2), acct(4), utmp(4).
STANDARDS CONFORMANCE
acctcms(1M)