Counting non empty fields and calculating with that number
Hello all,
I have a problem with a skript of mine:
My input has the following format
The first field is the sum of all fields after the $2. Now I want to add a field upfront that is the sum ($1) divided by the number of all fields that are not zero.
This is what I came up with until now:
However, this does not work. I ran into the problem dividing by zero, so I included a second if statement. I don't know if this is allowed, though.
Best,
Seb
---------- Post updated at 09:18 AM ---------- Previous update was at 09:13 AM ----------
Just found the solution: Leave the "BEGIN" out and it works ;D
Hey,
I have a file and it has only one field. I need to calculate the sum of each filed as total.
For e.g my file is
1
2
3
4
5
I need to calculate the total sum as 15.
Please let me know how i can do it? (4 Replies)
I need help counting the fields and field separators using Nawk.
I have a file that has multiple lines on it and I need to read the file 1 at a time and then count the fields and field separators and then store those numbers in variables. I then need to delete the first 5 fields and the blank... (3 Replies)
Hello all :)
I need some help; I'm running the sp_spaceused command on various tables and saving the output to a file. So, I have an input file that has 3 rows - each row has 7 columns. I would like to 1) sort the file on the 4th column, 2) take the 4th column in the first row and add 25% to... (2 Replies)
I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want.
The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Hi every one;
I have a 31500-line text file upon which two following tasks are to be performed:
1: Rearranging the file
2: Taking the average of each column (considering number of zeros) and output the result into a new file
This is the code I've come up with:
awk '(NR%3150<3150)... (0 Replies)
I'm facing a strange problem, please help me out.
Here we go.
I want to count number of fields in particular file.
filename and delimiter character will be passed through parameter.
On command prompt if i type following i get 27 as output (which is correct)
cat customer.dat | head -1 | awk... (12 Replies)
I am trying to figure out a way in nawk to 1) get a count of the number of times a value appears in field 1 and 2) count each time the same value appears in field 2 for each value of field 1. So for example, if I have a text file with the following:
grapes, purple
apples, green
squash, yellow... (2 Replies)
ok, so a user can specify options as is shown below:
ExA:
cpu.pl!23!25!-allow
or
ExB:
cpu.pl!23!25!-block!all
options are delimited by the exclamation mark.
now, in example A, there are 4 options provided by the user.
in example B, there are 5 options provided by the user.
... (3 Replies)
When cut encounters consecutive delimiters it seems to count each instance as a field, at least with spaces. Is this typical behavior for any delimiter?
#:~$ ifconfig eth0 | grep HWaddr
eth0 Link encap:Ethernet HWaddr 94:de:80:a7:6d:e1
#:~$ ifconfig eth0 | grep HWaddr | cut -d " " -f... (6 Replies)
Hi,
Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account.
$ head -500 x.txt y.txt
==> x.txt <==
TEST01 APP_USER_PROFILE
USER03 APP_USER_PROFILE
TEST02 APP_USER_EXP_PROFILE
TEST04 APP_USER_PROFILE
USER01 ... (3 Replies)
Discussion started by: newbie_01
3 Replies
LEARN ABOUT DEBIAN
empty-page
EMPTY-PAGE(1) ExactImage Manual EMPTY-PAGE(1)NAME
empty-page - empty page detector of the ExactImage toolkit
SYNOPSIS
empty-page [option...] {-i | --input} input-file
empty-page {-h | --help}
DESCRIPTION
ExactImage is a fast C++ image processing library. Unlike many other library frameworks it allows operation in several color spaces and bit
depths natively, resulting in low memory and computational requirements.
empty-page counts dark pixels of a black and white image and decides with a threshold whether the page is most probably empty, and thus can
be removed from the image processing stream.
OPTIONS -i file, --input file
Read image from the specified file.
-m n, --margin n
Set width of border margin to skip. For speed reasons, the margin has to be a multiple of 8. The default is 16.
-p x, --percentage x
Set fraction of permissible dark pixels. The default is 0.05 (5%).
-h, --help
Display help text and exit.
EXAMPLES
$ empty-page -i test.tif
The image has 75461 dark pixels from a total of 1060992 (7.11231%).
non-empty
EXIT STATUS
The exit status is 0 if the image is mostly white, 1 otherwise.
SEE ALSO exactimage(7)AUTHORS
Jakub Wilk <jwilk@debian.org>
Wrote this manual page for the Debian system.
http://www.exactcode.de/site/open_source/exactimage/
This manual page incorporates texts found on the ExactImage homepage.
COPYRIGHT
This manual page was written for the Debian system (and may be used by others).
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or (at
your option) any later version published by the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL-2.
empty-page 09/09/2013 EMPTY-PAGE(1)