04-22-2010
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 (which I've done using cut), add them all together then divide by the total number of rows. Really struggling with this! Help much appreciated
abcd e544f222e0jk55 1503
abcd e544f222e0jk56 1504
abcd e544f222e0jk57 1505
abcd e544f222e0jk58 1506
abcd e544f222e0jk59 1507
abcd e544f222e0jk60 1508
abcd e544f222e0jk61 1509
abcd e544f222e0jk62 1510
abcd e544f222e0jk63 1511
abcd e544f222e0jk64 1512
abcd e544f222e0jk65 1513
abcd e544f222e0jk66 1514
abcd e544f222e0jk67 1515
abcd e544f222e0jk68 1516
abcd e544f222e0jk69 1517
abcd e544f222e0jk70 1518
abcd e544f222e0jk71 1519
abcd e544f222e0jk72 1520
abcd e544f222e0jk73 1521
abcd e544f222e0jk74 1522
abcd e544f222e0jk75 1523
abcd e544f222e0jk76 1524
abcd e544f222e0jk77 1525
abcd e544f222e0jk78 1526
abcd e544f222e0jk79 1527
abcd e544f222e0jk80 1528
abcd e544f222e0jk81 1529
abcd e544f222e0jk82 1530
abcd e544f222e0jk83 1531
abcd e544f222e0jk84 1532
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hey all,
I ran some simulations, of which the output is 100s of files. I've used grep to extract the vital information needed from the files. This has made my task somewhat easier. But I still need to perform some mathematical calculations (average and geometrical average) on the results of the... (9 Replies)
Discussion started by: slackjack
9 Replies
2. UNIX for Dummies Questions & Answers
I need to extract all the p-value numbers and the rho numbers from a .txt file and write them as coma separated values in a new file. Ideally I would get two files in the end, one for p- values and one for rho. Any suggestions? I appreciate your help!!!
The .txt file looks essentially like this... (5 Replies)
Discussion started by: eggali
5 Replies
3. Shell Programming and Scripting
Hello All,
I need to extract lines from a file that contains ALPHANUMERIC and the length of Alphanumeric is set to 16. I have pasted the sample of the lines from the text file that I have created.
My problem is that sometimes 16 appears in other part of the line. I'm only interested to... (14 Replies)
Discussion started by: mnassiri
14 Replies
4. UNIX Desktop Questions & Answers
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
5. UNIX for Dummies Questions & Answers
Hi,
I am trying to extract lines from a text file given a text file containing line numbers to be extracted from the first file. How do I go about doing this? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
6. Shell Programming and Scripting
If you have a look at this thread, you'll see that users have been posting the output a script which are numbers that range from 2 to 5 decimal places. If I dump this entire thread to txt file, how can I:
1) Delete everything except for numbers of the following formats (where 'x' is a digit and... (5 Replies)
Discussion started by: graysky
5 Replies
7. Shell Programming and Scripting
I have used this color prompt on my servers for long time, in file ~\.bashrc
Black="\"
Dark="\"
Blue="\"
LBlue="\"
Green="\"
LGreen="\"
Cyan="\"
LCyan="\"
Red="\"
LRed="\"
Purple="\"
LPurple="\"
Brown="\"
Yellow="\"
LGray="\"
White="\"
Reset="\"
PS1="$Yellow\u@\h $LBlue\w... (4 Replies)
Discussion started by: Jotne
4 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I am trying to grep/extract the number list from this log file, can I get some help on this. I can grep the word 'href' to see the numbers, but it is resulting with the complete line.
Content of my file:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
<head>... (4 Replies)
Discussion started by: Sajjadmehdi
4 Replies
9. Shell Programming and Scripting
Hello friends,I am new to Unix programming.
how do I achieve the following in Unix shell script (I am running ksh on AIX)
extract the number from name of file?
My file format is like "LongFileName-1234.020614-221030.txt"
now I want to extract value which is between (-) hyphen and (.) dot... (4 Replies)
Discussion started by: f150
4 Replies
10. Shell Programming and Scripting
Hi all
I have created a script to allow me to gain a number of file times and how long they take to execute. I have been asked to get the average time for the log. The log will update every 5 minutes and never be empty.
141
152
157
161
168
169
171
179
202
207
229
651
666
714... (3 Replies)
Discussion started by: simpsa27
3 Replies
LEARN ABOUT CENTOS
ppix::regexp::token::literal
PPIx::Regexp::Token::Literal(3) User Contributed Perl Documentation PPIx::Regexp::Token::Literal(3)
NAME
PPIx::Regexp::Token::Literal - Represent a literal character
SYNOPSIS
use PPIx::Regexp::Dumper;
PPIx::Regexp::Dumper->new( 'qr{foo}smx' )
->print();
INHERITANCE
"PPIx::Regexp::Token::Literal" is a PPIx::Regexp::Token.
"PPIx::Regexp::Token::Literal" has no descendants.
DESCRIPTION
This class represents a literal character, no matter how specified.
METHODS
This class provides the following public methods. Methods not documented here are private, and unsupported in the sense that the author
reserves the right to change or remove them without notice.
ordinal
print 'The ordinal of ', $token->content(),
' is ', $token->ordinal(), "
";
This method returns the ordinal of the literal if it can figure it out. It is analogous to the "ord" built-in.
It will not attempt to determine the ordinal of a unicode name ("N{...}") unless charnames has been loaded, and supports the vianame()
function. Instead, it will return "undef". Users of Perl 5.6.2 and older may be out of luck here.
Unicode code points (e.g. "N{U+abcd}") should work independently of charnames, and just return the value of "abcd".
It will never attempt to return the ordinal of an octet ("C{...}") because I don't understand the syntax.
SUPPORT
Support is by the author. Please file bug reports at <http://rt.cpan.org>, or in electronic mail to the author.
AUTHOR
Thomas R. Wyant, III wyant at cpan dot org
COPYRIGHT AND LICENSE
Copyright (C) 2009-2013 by Thomas R. Wyant, III
This program is free software; you can redistribute it and/or modify it under the same terms as Perl 5.10.0. For more details, see the full
text of the licenses in the directory LICENSES.
This program is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of
merchantability or fitness for a particular purpose.
perl v5.16.3 2014-06-10 PPIx::Regexp::Token::Literal(3)