How to Sum a column in AWK?

You could sum the column 57 of your file, and print it using

awk '{split($0,a,","); sum += a[57]} END {print sum}'

Related Posts:

  1. How to split a delimited string into an array in awk?
  2. How to pretty print XML from the command line?
  3. What are file descriptors, explained in simple terms?
  4. How to kill a process running on particular port in Linux?
  5. Display exact matches only with grep
  6. Display exact matches only with grep
  7. What does ^M character mean in Vim?
  8. What does it mean to write to stdout in C?
  9. What do ‘real’, ‘user’ and ‘sys’ mean in the output of time(1)?
  10. mkdir’s “-p” option
  11. wait(null) and wait(&status) C language and Status
  12. Shell script “for” loop syntax
  13. How to get the current directory in a C program?
  14. When could or should I use chmod g+s on a file or directory?
  15. Equivalent of *Nix ‘which’ command in PowerShell?
  16. What is the difference between SIGSTOP and SIGTSTP?
  17. How to colorize diff on the command line
  18. How to colorize diff on the command line
  19. How to read a file into a variable in shell?
  20. gpg decryption fails with no secret key error
  21. What is the difference between tar and zip?
  22. Display current path in terminal only
  23. What do the dup() and dup2() systems really do?
  24. What generates the “text file busy” message in Unix?
  25. Reasoning behind C sockets sockaddr and sockaddr_storage
  26. How can I send an email through the UNIX mailx command?
  27. Rename multiple files based on pattern in Unix
  28. What is the difference between a symbolic link and a hard link?
  29. SCP Permission denied (publickey). on EC2 only when using -r flag on directories
  30. binary operator expected error when checking if a file with full pathname exists
  31. What is special about /dev/tty?
  32. How do I do ‘mount –bind’ in /etc/fstab?
  33. How to read backward from the end of file in less or more?
  34. Getting the last match in a file using grep
  35. How do I pause my shell script for a second before continuing?
  36. What is newline character — ‘\n’
  37. Why does ENOENT mean “No such file or directory”?
  38. sudo: npm: command not found
  39. In the shell, what does ” 2>&1 ” mean?
  40. How do I grep recursively?
  41. In the shell, what does ” 2>&1 ” mean?
  42. How to grep for case insensitive string in a file?
  43. grep –ignore-case –only
  44. What are .a and .so files?
  45. How do I grep recursively?
  46. OS X: equivalent of Linux’s wget
  47. Connect: Socket operation on non-socket
  48. What is the difference between read and pread in unix?
  49. OS X: equivalent of Linux’s wget
  50. How do I use grep to search the current directory for all files having the a string “hello” yet display only .h and .cc files?
  51. SSH using python script
  52. How can I exclude directories from grep -R?
  53. Argument list too long error for rm, cp, mv commands
  54. Difference between using “chmod a+x” and “chmod 755”
  55. What is a bus error? Is it different from a segmentation fault?
  56. What are NR and FNR and what does “NR==FNR” imply?
  57. Who can access a file with octal permissions “000” on Linux/UNIX?
  58. How to cat <> a file containing code?
  59. Using awk to remove the Byte-order mark
  60. Given two directory trees, how can I find out which files differ by content?
  61. Diff command along with Grep gives “Binary file (standard input) matches”
  62. OSError – Errno 13 Permission denied
  63. What is cp: cannot stat error in Unix, I get this error when trying to copy thing from one folder to another
  64. Printing the last column of a line in a file
  65. What is a bus error? Is it different from a segmentation fault?
  66. What can cause a “Resource temporarily unavailable” on sock send() command
  67. How to download a file from server using SSH?
  68. What is the ASCII Code of ½?
  69. Get Unix timestamp with C++
  70. What is the difference between “#!/usr/bin/env bash” and “#!/usr/bin/bash”?
  71. Absolute value in awk doesn’t work?
  72. Why should we check WIFEXITED after wait in order to kill child processes in Linux system call?
  73. Command to change the default home directory of a user
  74. Use of `NF` in awk command
  75. Is there any simple way to benchmark Python script?
  76. What is the difference between sed and awk?
  77. What does “&” at the end of a linux command mean?
  78. Can’t remove a directory in Unix
  79. Which of sprintf/snprintf is more secure?
  80. Syntax error near unexpected token ‘then’
  81. C fopen vs open
  82. Shell script not running, command not found
  83. Reaching EOF with fgets
  84. How can I do a recursive find/replace of a string with awk or sed?
  85. Difference between sh and Bash
  86. How do I write stderr to a file while using “tee” with a pipe?
  87. What are the uses of the exec command in shell scripts? 
  88. How do I get the current Unix time in milliseconds in Bash?
  89. Copying a large directory tree locally? cp or rsync?
  90. Can I nohup/screen an already-started process?
  91. In my /etc/hosts/ file on Linux/OSX, how do I do a wildcard subdomain?
  92. When does /tmp get cleared?
  93. SSL Certificate Location on UNIX/Linux
  94. What does ‘set -e’ do, and why might it be considered dangerous?
  95. How to remove empty/blank lines from a file in Unix (including spaces)?
  96. How to forcibly close a socket in TIME_WAIT?
  97. How can I rename a Unix user?
  98. Can you have more than one ~/.ssh/config file?
  99. How to check what port mysql is running on
  100. Do you have any useful awk and grep scripts for parsing apache logs? [closed]

Leave a Comment