Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

to calculate column total

Name: Nick
Date: October 10, 2002 at 07:07:50 Pacific
OS: unix
CPU/Ram: 256

Comment:

Hi, I need help. I have the following input file: TT,23423.11 YIE,1290.45 SIA,23477.92 ... ... I need a script that will sum up the value from the second column of this file and output a total value. Thanks

Name: James Boothe
Date: October 10, 2002 at 07:28:41 Pacific

Reply:

awk -F"," '{col2=col2+$2} END {printf "Total: %12f\n",col2}' myfile or to round to two decimal places, use: printf "Total: %12.2f\n",col2}

0

Reply:

The awk solution above is best for what you are trying to do. However, floating point can be done in the shell by piping a string to bc. An example: #!/bin/sh IFS=, string="0" while read col1 col2 do if [ col2 != "" ] then string="$string+$col2" fi done < junk1.dat echo "scale=2;$string" | bc The ouput from your data file is: 48191.48

0

unix

kill

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: i need help! can someone help me please? i try to calculate date under unix (ksh)... example: todays date: 2003.07.23 date-5 = 2003.07.28 how can i do calculate? i know that it is not possible with th...

Summary: Hi Experts, Using unix-KSH script, we need to calculate the difference between two time intervals. for example; time_a=04:35:54 time_b=00:00:05 (pls. note that this shows only seconds) Now, the...

Summary: Hi - How can I use awk to take names (i.e. D,Liz W,Frank) listed in one row and display in a column? First and Last Name are seperated by a "," and a space defines each field. Example - Writing a she...