Bash conditional sum

# Basic syntax:
awk '{ if ( condition ) { sum += $field; }} END { print sum }' your_file
# Where:
#	- $field is the field to sum if the condition is true

# Example usage:
# Sum all fields of column 5 in your_file that don't have "*" in field 3
awk '{ if ($3 != "*" ) { sum += $5; }} END { print sum }' your_file
# Note, explicitly setting your_file's field delimiter with 
#	"BEGIN { FS="<input_delimiter>" };" might be needed for non-standard 
#	delimiters

Source: unix.com

Similar codes

6 votes368 views1 answer
Auto clear cache and swap ubuntu
Shell/Bash
0 vote333 views1 answer
Install kubectx
Shell/Bash
1 vote331 views2 answers
Linux test if string exists in file
Shell/Bash
-3 votes357 views2 answers
How to run sql script in docker container
Shell/Bash
2 votes338 views2 answers
Git branch order by date
Shell/Bash
1 vote379 views1 answer
Check owner of process id linux
Shell/Bash
11 votes341 views3 answers
Docker remove none images
Shell/Bash
0 vote346 views1 answer
Openssl convert openssh to rsa
Shell/Bash
0 vote351 views1 answer
Get total hdd space linux
Shell/Bash
0 vote374 views1 answer
Abort current task mac terminal
Shell/Bash