## Stuck with awk !!!

Stuck with awk !!!
# 1
09-14-2013
Stuck with awk !!!

Can someone help me with geting the desired output?

Source:

Output: (Should calculate the percentage of each bank's error)

I did the following:

It is generating output as :

Can someone help me with getting the desired output?

TIA
 zsycho View Public Profile for zsycho Find all posts by zsycho
# 2
09-14-2013
Use printf "%.2f" to round to 2 decimal places (assuming that's your only problem, which I can see from the output).
 Scott View Public Profile for Scott Find all posts by Scott
# 3
09-14-2013
Quote:
Originally Posted by Scott
Use printf "%.2f" to round to 2 decimal places (assuming that's your only problem, which I can see from the output).
If you see the output carefully, you will see that the output shows 100.000000 for Result code [0] even though it should not be 100, it should be 91.30 for Bank1.sss.

The first column data is the success rate in percentage for any error for a particular bank.

Eg:
For Bank 1,

total entries : 63+2+4=69
63/69*100 = 91.30
2/69*100 = 2.89 ... and so on.
 zsycho View Public Profile for zsycho Find all posts by zsycho
# 4
09-14-2013
Without any precision, it will never know how to round correctly.

 Scott View Public Profile for Scott Find all posts by Scott
# 5
09-14-2013
You get higher precision with
and even higher enforcing floating point
# 6
09-14-2013
hmm, I am aware of that but since I am new to awk, its getting difficult for me to generate the required output.

I need to know what needs to be changed in the following command

so that I can get the output as

The problem with the above awk command is :

At first, the value of s is 63. so it creates percentage as 63/63*100 = 100 %
then, the value of s is 63+2 i.e 65. so it creates percentage as 2/65*100 = 3.07 % and so on... I hope you got the point.

How can I change the command such that awk will create percentage only for the entries between ".sss" , calculate the sum and then percentage. Then move to the next loop i.e the entries between next set ".sss".

I am getting the proper sum for every set but not correct percentage.

Last edited by zsycho; 09-14-2013 at 03:36 PM..
 zsycho View Public Profile for zsycho Find all posts by zsycho
# 7
09-14-2013
 Scott View Public Profile for Scott Find all posts by Scott

## stuck on assignment

I was given this to do, Write a Shell script to automatically check that a specified user is logged in to the computer. The program should allow the person running the script to specify the name of the user to be checked, the frequency in seconds at which the script should check. If a...

## 2. Linux

I am developing a multi-threaded library that helps the transformation of messages between threads in different processes using shared memory. I am using the pthreads condition facility in order to synchronize access to the shared memory slots through which the messages are passed. My test...

## awk getting stuck after BEGIN

I am beginner in awk awk 'BEGIN{for(i=1;(getline<"opnoise")>0;i++) arr=\$1}{print arr}' In the above script, opnoise is a file, I am reading it into an array and then printing the value corresponding to index 20. Well this is not my real objective, but I have posted this example to describe...

## I am stuck in my script

Hi All I have script that find 777 dir with specific extension like .php .Now after finding all 777 directory i will place in httpd.conf using a directory directive ,Now i was not do that,if directory entry exitst in httpd.conf then script ignor it dont show me at stdout else if it dont find...

## help! im stuck..

I want to search for the line with the group name and add the user into the group. The file format is the same as /etc/group The code i wrote is egrep "^\$newGID" \$group >/dev/null FS=":" oldData=awk -F: '{print \$3}' newData= "\$oldData,\$newUser" sed -n \$4/\$newData \$group but a friend...

## really stuck- need to get a variable within a variable- AWK

Hi all, I have been struggling with this all day, and it is key to a conversion database I have to write. The data converts the information out of an array using AWK, and basically all I have to do is figure out how to get the value of a variable inside a variable. Right now at its...

## I'm stuck :(

Suppose that I have some data: 12,30 12,45 2,3 7,8 3,9 30, 8 45,54 56,65 Where (a,b) indicates that a is connected to b. I want to get all connected nodes to one point. For instance, the output of the above example should be something like: Group 1 2,3 3,9 Group 2 12,30 12,45...

## stuck and confused

#!/bin/bash echo \$1 | cat - \$2 >> /tmp/\$\$ && mv /tmp/\$\$ \$2 im trying to get the first argument to go in the middle of the second argument which is a file, anyone any ideas. i have only managed to get it to go on the end or the front. been fiddling about with wc -l, i get the number of lines...

## Got stuck so plz help

I'm having problem writing a shell script using bash that takes a file as an argument. The script should be able to determine what permissions the owner, group and everybody has for the file passed in. could anyone plz help me out.

## stuck....!

I have been busy reading away on devices and filesystems and I am stuck on a particular subject matter.. I'm not understanding the concept behind mknod mkfifo makedev or related commands.. can anyone shed some light on the subject.! any feedback welcome! moxxx68