04-18-2007
Formatind and calculating output
Hello every one,
I an new th shell script.
I am using this script to format output.
nawk -f nawk_a.sc doit1
and
HTML Code:
BEGIN{FS=":"
printf "\n\t\t\t***CAMPAIGN 1998 CONTRIBUTIONS***\n\n"
print "-------------------------------------------------------------------------------"
printf"Name\t\t\tPHONE\t\t| Jan | Feb | Mar | Total Donated\n"
print "--------------------------------------------------------------------------------"
}
{tot=$3+$4+$5}
qtr_tot=qtr_tot+tot
{printf"%-20s\t%s\t%4.2f\t%4.2f\t%3.2f\t%3.2f\n",$1,$2,$3,$4,$5,tot}
END{print "-------------------------------------------------------------------------------"
print"\t\t\t\t SUMMARY"
print "-------------------------------------------------------------------------------"
{printf"The total reveived for this quater is :$%6.2f\n",qtr_tot}
{printf"The the avgerage total :$%6.2f\n",qtr_tot/12}
}
thank you in advace
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
This is the cronjob
----------------------
root@a7germ:/home/paxtemp > crontab -l|grep test
57 * * * * /home/paxtemp/test_1.sh
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/paxtemp/test.sh
root@a7germ:/home/paxtemp >
This is the contents of test.sh script... (2 Replies)
Discussion started by: kekanap
2 Replies
2. Shell Programming and Scripting
Hello all :)
I need some help; I'm running the sp_spaceused command on various tables and saving the output to a file. So, I have an input file that has 3 rows - each row has 7 columns. I would like to 1) sort the file on the 4th column, 2) take the 4th column in the first row and add 25% to... (2 Replies)
Discussion started by: stonemonolith
2 Replies
3. Shell Programming and Scripting
hi all,
have got a ksh script which tries to monitor memory usage of app servers. i do a ps -0 rss -p <PID> to get the memory size in KB but when i divide by 1024 to convert to MB i dont know how to round it up ??
thanks in advance. (3 Replies)
Discussion started by: cesarNZ
3 Replies
4. UNIX for Dummies Questions & Answers
Hi,
i have 12 float variables in a bash file and i want to calculate the average of them.
Can any body help? (6 Replies)
Discussion started by: limadario
6 Replies
5. Shell Programming and Scripting
I need to help to calculating using date in a script.
One application is licensed by date, some month at a time.
I can read the date from system and get an output like this:
echo $status
6A34 System4 01.01.11-31.01.11
My goal is to use license date 31.01.11 and subtract todays date... (7 Replies)
Discussion started by: Jotne
7 Replies
6. Shell Programming and Scripting
Hi All,
I have the following time stamp data in 2 columns
Date TimeStamp(also with milliseconds)
05/23/2012 08:30:11.250
05/23/2012 08:30:15.500
05/23/2012 08:31.15.500
.
.
etc
From this data I need the following output.
0.00( row1-row1 in seconds)
04.25( row2-row1 in... (5 Replies)
Discussion started by: ks_reddy
5 Replies
7. Shell Programming and Scripting
Hi all,
I have the following code in a shell script.
Code:
if
then
echo "##"
echo "##"
echo "##################################"
for fn in `find "$1" -maxdepth 1 -iname \*"$2"* -type f`
do
echo "$fn"
... (2 Replies)
Discussion started by: naveendronavall
2 Replies
8. Shell Programming and Scripting
Hi.
I have a LOOONG list of samples but I am not sure how to write the loop/script to calculate the mean...
I normally use awk...
...................MEAN
Sample1 25.82 40.61333
Sample1 47.6
Sample1 48.42
Sample2 54.03 54.12
Sample2 53.98
Sample2 54.35
etc.....
I would like to... (4 Replies)
Discussion started by: danieladna
4 Replies
9. UNIX for Dummies Questions & Answers
Hi
I have file like below
111,victor,48,12,36
342,Peter,54,58,30
476,Scott,25,36,48
567,Patty,74,17,95
I have written below code to calcualte avereage for every id
Victor = 48+12+36/3
#!/bin/ksh
/usr/xpg4/bin/awk '
BEGIN {FS=","} {sum=0; n=0;i=3 (1 Reply)
Discussion started by: stew
1 Replies
10. Shell Programming and Scripting
Hi All,
I want to read the input file and store the output in the Output file. I pasted the sample Input and Output file below. Help me with this.
Input file
=================================
ITEM1 AAAAA 1
ITEM1 BBBBB 1
ITEM1 CCCCC 1
ITEM2 AAAAA 5
ITEM2 CCCCC 4... (1 Reply)
Discussion started by: humaemo
1 Replies
LEARN ABOUT PHP
maxdb_multi_query
MAXDB_MULTI_QUERY(3) 1 MAXDB_MULTI_QUERY(3)
maxdb_multi_query - Performs a query on the database
Procedural style
SYNOPSIS
bool maxdb_multi_query (resource $link, string $query)
DESCRIPTION
Object oriented style
bool maxdb::multi_query (string $query)
The maxdb_multi_query(3) works like the function maxdb_query(3). Multiple queries are not yet supported.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$query = "SELECT * FROM dual";
/* execute multi query */
if ($maxdb->multi_query($query)) {
do {
/* store first result set */
if ($result = $maxdb->store_result()) {
while ($row = $result->fetch_row()) {
printf("%s
", $row[0]);
}
$result->close();
}
/* print divider */
if ($maxdb->more_results()) {
printf("-----------------
");
}
} while ($maxdb->next_result());
}
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$query = "SELECT * FROM dual";
/* execute multi query */
if (maxdb_multi_query($link, $query)) {
do {
/* store first result set */
if ($result = maxdb_store_result($link)) {
while ($row = maxdb_fetch_row($result)) {
printf("%s
", $row[0]);
}
maxdb_free_result($result);
}
/* print divider */
if (maxdb_more_results($link)) {
printf("-----------------
");
}
} while (maxdb_next_result($link));
}
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
a
SEE ALSO
maxdb_use_result(3), maxdb_store_result(3), maxdb_next_result(3), maxdb_more_results(3).
PHP Documentation Group MAXDB_MULTI_QUERY(3)