Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Average result of text file
Top Forums Shell Programming and Scripting Average result of text file Post 303026253 by Corona688 on Thursday 22nd of November 2018 10:40:21 AM
Old 11-22-2018
Code:
awk '
# Code inside { } braces without other qualifiers is run once per line
{ 
        # Add the current line, $0, to the total in s.  The +0 guarantees its treated as a number, not a string.
        s+=$0+0
        # Store the current record (line) count inside the fnr variable.  FNR is a special variable meaning file record number.
        fnr=FNR
}
# This code runs once, after myFile has been processed.
END {
        # Print the sum, divided by the number of records, to two decimal places
        printf("%.2f\n", s/fnr)
}' myFile

Last edited by Corona688; 02-05-2019 at 03:27 PM..
This User Gave Thanks to Corona688 For This Post:
vgersh99
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Outputting formatted Result log file from old 30000 lines result log<help required>

Well I have a 3000 lines result log file that contains all the machine data when it does the testing... It has 3 different section that i am intrsted in 1) starting with "20071126 11:11:11 Machine Header 1" 1000 lines... "End machine header 1" 2) starting with "20071126 12:12:12 Machine... (5 Replies)
Discussion started by: vikas.iet
5 Replies

2. Shell Programming and Scripting

Extract numbers from text file work out average

Just wondering if someone could assist me with shell script I'm trying to write. I need to read the final column of a text file (shown below) and workout what the average number is. The text file will have a variable number of lines, I just want the script to pull out the values in the final field... (14 Replies)
Discussion started by: rich@ardz
14 Replies

3. Shell Programming and Scripting

Displaying Result to a Text File

Hi; I am scripting in Shell and i want to write output (on screen) to a text file? ... | tee gcsw/output.txt doesnot work? :(:( (6 Replies)
Discussion started by: gc_sw
6 Replies

4. Shell Programming and Scripting

Append Text in Result File Name

Hi Below command is returning the list of files which having this string "MTL_SYSTEM_ITEMS". find . -name "*"|xargs grep -il MTL_SYSTEM_ITEMS Ex: Above command is returing 2 files (Out of 10 files 2 files having this string). ./file1.txt and ./file2.txt Here I want to append... (3 Replies)
Discussion started by: balajiora
3 Replies

5. Shell Programming and Scripting

Computing average values from multiple text files

Hi, first, I have searched in the forum for this, but I could not find the right answer. (There were some similar threads, but I was not sure how to adapt the ideas.) Anyway, I have a quite natural problem: Given are several text files. All files contain the same number of lines and the same... (3 Replies)
Discussion started by: rbredereck
3 Replies

6. UNIX Desktop Questions & Answers

Calculate average for rows in a text file

Dear Gurus, I have tab-delimited text files with matrix containing values. The first column is a identifier and other columns have the corresponding values. I would like to calculate the average value (total number/number of entries) for all entries from 2nd column to the last column in row... (3 Replies)
Discussion started by: Unilearn
3 Replies

7. Shell Programming and Scripting

How to output thre result to a text file?

Dear All I have a script file like the following: ..... ..... Variable_1 = 888 Variable_2 = 999 ..... MyExternalProgram Myfile ..... The line MyExternalProgram Myfile will generate some number, Say 777 Now I hope I can output the result of above codes to a text file,... (2 Replies)
Discussion started by: littlewenwen
2 Replies

8. Shell Programming and Scripting

Save result to a text file

Currently I have a perl code to combine two different files. #! /usr/bin/perl -w use strict; open FP1,"A.txt"; open FP2,"B.txt"; my ($l1,$l2); while(1) { $l1=<FP1>; chomp $l1; $l2=<FP2>; chomp $l2; last unless(defined $l1 or defined $l2); print "$l1 $l2\n"; } close FP2;... (4 Replies)
Discussion started by: Tzeronone
4 Replies

9. Shell Programming and Scripting

Hit multiple URL from a text file and store result in other test file

Hi, I have a problem where i have to hit multiple URL that are stored in a text file (input.txt) and save their output in different text file (output.txt) somewhat like : cat input.txt http://192.168.21.20:8080/PPUPS/international?NUmber=917875446856... (3 Replies)
Discussion started by: mukulverma2408
3 Replies

10. Shell Programming and Scripting

awk to parse file and display result based on text

I am trying using awk to open an input file and check a column 2/field $2 and if there is a warning then that is displayed (variantchecker): G not found at position 459, found A instead. The attached Sample1.txt is that file. If in that column/field there is a black space, then the text after... (6 Replies)
Discussion started by: cmccabe
6 Replies

LEARN ABOUT DEBIAN

tcfmgr

TCFMGR(1)							   Tokyo Cabinet							 TCFMGR(1)

NAME

       tcfmgr - the command line utility of the fixed-length database API

DESCRIPTION

       The  command `tcfmgr' is a utility for test and debugging of the fixed-length database API and its applications.  `path' specifies the path
       of a database file.  `width' specifies the width of the value of each record.  `limsiz' specifies the limit  size  of  the  database  file.
       `key' specifies the key of a record.  `value' specifies the value of a record.  `file' specifies the input file.

	      tcfmgr create path [width [limsiz]]
		     Create a database file.
	      tcfmgr inform [-nl|-nb] path
		     Print miscellaneous information to the standard output.
	      tcfmgr put [-nl|-nb] [-sx] [-dk|-dc|-dai|-dad] path key value
		     Store a record.
	      tcfmgr out [-nl|-nb] [-sx] path key
		     Remove a record.
	      tcfmgr get [-nl|-nb] [-sx] [-px] [-pz] path key
		     Print the value of a record.
	      tcfmgr list [-nl|-nb] [-m num] [-pv] [-px] [-rb lkey ukey] [-ri str] path
		     Print keys of all records, separated by line feeds.
	      tcfmgr optimize [-nl|-nb] path [width [limsiz]]
		     Optimize a database file.
	      tcfmgr importtsv [-nl|-nb] [-sc] path [file]
		     Store records of TSV in each line of a file.
	      tcfmgr version
		     Print the version information of Tokyo Cabinet.

       Options feature the following.

	      -nl : enable the option `FDBNOLCK'.
	      -nb : enable the option `FDBLCKNB'.
	      -sx : the input data is evaluated as a hexadecimal data string.
	      -dk : use the function `tcfdbputkeep' instead of `tcfdbput'.
	      -dc : use the function `tcfdbputcat' instead of `tcfdbput'.
	      -dai : use the function `tcfdbaddint' instead of `tcfdbput'.
	      -dad : use the function `tcfdbadddouble' instead of `tcfdbput'.
	      -px : the output data is converted into a hexadecimal data string.
	      -pz : do not append line feed at the end of the output.
	      -m num : specify the maximum number of the output.
	      -pv : print values of records also.
	      -rb lkey ukey : specify the range of keys.
	      -ri str : specify the interval notation of keys.
	      -sc : normalize keys as lower cases.

       This command returns 0 on success, another on failure.

SEE ALSO

       tcftest(1), tcfmttest(1), tcfdb(3), tokyocabinet(3)

Man Page							    2011-02-12								 TCFMGR(1)
All times are GMT -4. The time now is 06:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy