Home > IT Answers > Database > Sum Values Of A Particular Column In A Tilde Delimited File on Solaris
Gchahl
25 pts.
 Sum Values Of A Particular Column In A Tilde Delimited File on Solaris
Database, DataManagement, Development, Unix
Hello All: I need to sum the values in the 3rd column in my tilde delimited file on Soalris. Is there any command that will let me do this? Thanks

Software/Hardware used:
ASKED: September 4, 2008  2:01 PM
UPDATED: September 6, 2008  1:43 AM
RELATED QUESTIONS
Answer Wiki:
<pre>awk -F~ '{total+=$3} END{print total}' /tmp/foo</pre> assuming your file is /tmp/foo. You may have to use gawk instead of awk on Solaris. I don't have a solaris box to try it on.
Last Wiki Answer Submitted:  September 6, 2008  1:43 am  by  MarkK   645 pts.
All Answer Wiki Contributors:  MarkK   645 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _