Sponsored Content
Top Forums Shell Programming and Scripting how can i calculate a file using awk Post 302256572 by whizkidash on Monday 10th of November 2008 06:21:19 AM
Old 11-10-2008
how can i calculate a file using awk

hi all
Am new to scripting...
So,i have a file named file1 its contents are as follows:

joy 55 66 77
ruby 77 88 99
saloni 88 44 33

I would require a script which will calculate its percentage,its total and the average with awk script

Many thanks in advance..
Please reply me at the earliest

regards
whizkid
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to calculate with awk

Hi, I have below awk statement and I need to convert the second field ( substr($0,8,6))from minutes to hours with 2 decimail place. How can I achieve this? /usr/bin/awk '{print substr($0,23,4),substr($0,8,6)}' /tmp/MANAGER_LIST.$$ >> /tmp/NEWMANAGER_LIST.$$ Thanks for any help! (4 Replies)
Discussion started by: whatisthis
4 Replies

2. UNIX for Dummies Questions & Answers

Use awk to calculate average of column 3

Suppose I have 500 files in a directory and I need to Use awk to calculate average of column 3 for each of the file, how would I do that? (6 Replies)
Discussion started by: grossgermany
6 Replies

3. Shell Programming and Scripting

Need an AWK script to calculate the percentage

Hi I need a awk script to calculate percentage. I have to pass the pararmeters in to the awk script and calculate the percentage. Sum = 50 passed = 43 failed = 7 I need to pass these value in to the awk script and calculate the percentage. Please advice me. (8 Replies)
Discussion started by: bobprabhu
8 Replies

4. Shell Programming and Scripting

awk script to calculate total

Hi First field is the Record Type. A Record Type 5 can have multiple Record Type 6's before another Record Type 5 appears. I want to calculate the total of fields at position 8-11 on Record type 6 when Record Type 5 has a field at position 11-14 equals to '2222'. then it should delete the lines... (2 Replies)
Discussion started by: appsguy616
2 Replies

5. Shell Programming and Scripting

Calculate P Value -Awk

Is there any awk command to calculate P Value ?(Probability) Is it possib;e to calculate P va;ue for this data for ex? 7.891284 8.148193 7.749575 7.958188 7.887702 7.714877 8.141548 7.51845 8.27736 7.929853 7.92456 8.249126 7.989113 8.012573 8.351206 (2 Replies)
Discussion started by: stateperl
2 Replies

6. Shell Programming and Scripting

awk-calculate records of a text

I want to make a bash shell script that accepts as argument a file name (cars.txt) and: 1) calculates the total price per year and per model. 2) For each car that it's number starts with TK, I want to print the surname and name of the owner and the total cost for them. NBE3452... (3 Replies)
Discussion started by: Mark_orig
3 Replies

7. Shell Programming and Scripting

Calculate age of a file | calculate time difference

Hello, I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes... I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes. To do... (10 Replies)
Discussion started by: worm
10 Replies

8. Shell Programming and Scripting

Calculate Average AWK

I want to calculate the average line by line of some files with several lines on them, the files are identical, just want to average the 3rd columns of those files.:wall: Example file: File 1 001 0.046 0.667267 001 0.047 0.672028 001 0.048 0.656025 001 0.049 ... (2 Replies)
Discussion started by: AriasFco
2 Replies

9. Shell Programming and Scripting

AWK: calculate ratio of columns

Hi all, I have a tab-delimited text file in which i have a few columns which look like, X Y U V 2 3 4 5 4 5 3 4 6 4 3 2 For example, I want to calculate the ratio (X+Y)/(X+Y+U+V) for each row and print the output. X Y U V ... (3 Replies)
Discussion started by: mehar
3 Replies

10. Shell Programming and Scripting

awk to calculate total and percent off field in file

Trying to use awk to print the lines in file that have either REF or SNV in $3, add a header line, sort by $4 in numerical order. The below code does that already, but where I am stuck is on the last part where the total lines are counted and printed under Total_Targets, under Targets_less_than is... (4 Replies)
Discussion started by: cmccabe
4 Replies
RUBY(1) 						 Ruby Programmers Reference Manual						   RUBY(1)

NAME
ruby - Interpreted object-oriented scripting language SYNOPSIS
ruby [ --version ] [ -c ] [ -w ] [ -d ] [ -l ] [ -p ] [ -n ] [ -a ] [ -s ] [ -0[octal] ] [ -Kc ] [ -ecommand ] [ -Fpattern ] [ -i[extension] ] [ -Idir ] [ -rlibrary ] [ -S ] [ -v ] [ -x[directory] ] [ -Cdirectory ] [ -y] [ -- ] [ programfile ] [ argument ] ... PREFACE
Ruby is an interpreted scripting language for quick and easy object-oriented programming. It has many features to process text files and to do system management tasks (as in Perl). It is simple, straight-forward, and extensible. If you want a language for easy object-oriented programming, or you don't like the Perl ugliness, or you do like the concept of lisp, but don't like too much parentheses, Ruby may be the language of your choice. DESCRIPTION
Ruby's features are as follows: o Interpretive Ruby is an interpreted language, so you don't have to recompile programs written in Ruby to execute them. o Variables have no type (dynamic typing) Variables in Ruby can contain data of any type. You don't have to worry about variable typing. Consequently, it has a weaker com- pile time check. o No declaration needed You can use variables in your Ruby programs without any declarations. Variable names denote their scope, local, global, instance, etc. o Simple syntax Ruby has a simple syntax influenced slightly from Eiffel. o No user-level memory management Ruby has automatic memory management. Objects no longer referenced from anywhere are automatically collected by the garbage collec- tor built into the interpreter. o Everything is an object Ruby is the purely object-oriented language, and was so since its creation. Even such basic data as integers are seen as objects. o Class, inheritance, methods Of course, as an object-oriented language, Ruby has such basic features like classes, inheritance, and methods. o Singleton methods Ruby has the ability to define methods for certain objects. For example, you can define a press-button action for certain widget by defining a singleton method for the button. Or, you can make up your own prototype based object system using singleton methods, if you want to. o Mix-in by modules Ruby intentionally does not have the multiple inheritance as it is a source of confusion. Instead, Ruby has the ability to share implementations across the inheritance tree. This is often called `Mix-in'. o Iterators Ruby has iterators for loop abstraction. o Closures In Ruby, you can objectify the procedure. o Text processing and regular expression Ruby has a bunch of text processing features like in Perl. o Bignums With built-in bignums, you can for example calculate factorial(400). o Exception handling As in Java(tm). o Direct access to the OS Ruby can use most UNIX system calls, often used in system programming. o Dynamic loading On most UNIX systems, you can load object files into the Ruby interpreter on-the-fly. COMMAND LINE OPTIONS
Ruby interpreter accepts following command-line options (switches). They are quite similar to those of Perl. -0[octal] specifies the input record separator ($/) as an octal number. If no digit is given, the null character is taken as the separator. Other switches may follow the digits. -00 turns Ruby into paragraph mode. - 0777 makes Ruby read whole file at once as a single string since there is no legal character with that value. -a turns on auto-split mode when used with -n or -p. In auto-split mode, Ruby executes $F = $_.split at beginning of each loop. -c causes Ruby to check the syntax of the script and exit without executing. If there are no syntax errors, Ruby will print "Syntax OK" to the standard output. --copyright prints the copyright notice. -d --debug turns on debug mode. $DEBUG will set true. -e command specifies script from command-line while telling Ruby to not search argv for script filenames. -F pattern specifies input field separator ($;). -h --help prints a summary of the options. -i extension specifies in-place-edit mode. The extension, if specified, is added to old filename to make a backup copy. example: % echo matz > /tmp/junk % cat /tmp/junk matz % ruby -p -i.bak -e '$_.upcase!' /tmp/junk % cat /tmp/junk MATZ % cat /tmp/junk.bak matz -I directory used to tell Ruby where to load the library scripts. Directory path will be added to the load-path variable ($:'). -Kkcode specifies KANJI (Japanese) encoding. -l enables automatic line-ending processing, which means to firstly set $ to the value of $/, and secondly chops every line read using chop!. -n causes Ruby to assume the following loop around your script, which makes it iterate over filename arguments somewhat like sed -n or awk. while gets ... end -p acts mostly same as -n switch, but print the value of variable $_ at the each end of the loop. example: % echo matz | ruby -p -e '$_.tr! "a-z", "A-Z"' MATZ -r library causes Ruby to load the library using require. It is useful with switches -n or -p. -s enables some switch parsing for switches after script name but before any filename arguments (or before a --). Any switches found there are removed from ARGV and set the corresponding variable in the script. example: #! /usr/local/bin/ruby -s # prints "true" if invoked with `-xyz' switch. print "true " if $xyz -S makes Ruby use the PATH environment variable to search for script, unless if its name begins with a slash. This is used to emulate #! on machines that don't support it, in the following manner: #! /usr/local/bin/ruby # This line makes the next one a comment in ruby exec /usr/local/bin/ruby -S $0 $* On some systems $0 does not always contain the full pathname, so you need -S switch to tell Ruby to search for the script if neces- sary. To handle embedded spaces or such. A better construct than $* would be ${1+"$@"}, but it does not work if the script is being interpreted by csh. -v --verbose enables verbose mode. Ruby will print its version at the beginning, and set the variable `$VERBOSE' to true. Some methods print extra messages if this variable is true. If this switch is given, and no other switches are present, Ruby quits after printing its version. -T[level] turns on taint checks at the specified level (default 1). --version prints the version of Ruby interpreter. -w enables verbose mode without printing version message at the beginning. It set the `$VERBOSE' variable to true. -x[directory] tells Ruby that the script is embedded in a message. Leading garbage will be discarded until the first that starts with "#!" and contains the string, "ruby". Any meaningful switches on that line will applied. The end of script must be specified with either EOF, ^D (control-D), ^Z (control-Z), or reserved word __END__.If the directory name is specified, Ruby will switch to that directory before executing script. -C directory causes Ruby to switch to the directory. -y --yydebug turns on compiler debug mode. Ruby will print a bunch of internal state messages during compiling scripts. You don't have to specify this switch, unless you are going to debug the Ruby interpreter. AUTHOR
Ruby is designed and implemented by Yukihiro Matsumoto <matz@netlab.jp>. 2001-12-25 ruby 1.6 RUBY(1)
All times are GMT -4. The time now is 07:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy