Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: AWK script - extracting min and max values from selected lines
Top Forums Shell Programming and Scripting AWK script - extracting min and max values from selected lines Post 302595518 by grincz on Friday 3rd of February 2012 10:48:02 AM
Old 02-03-2012
Thanks for answering guys!

I figured out why I have this problem. In my file there are "." [dots] not "," [commas] between numbers and this was ruining my results.
Code:
BEGIN { max = -1; min = 1000 }
  $4 == "TB" {
    value = $5 ~ /^[[:alpha:]]$/ ? $9 : $8;  
    max = max < value ? value : max;
    min = min > value ? value : min;
  }
  END { printf "max = %.3f\n min = %.3f\n", max, min }

This changed script from @bieri is working for me - I had to change min value because when it was set to -1 the result was -1 as well [there were no smaller values in the file].

Do You have any propositions how I could obtain results without changing all the [dots] to [commas]?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

max values amd min values

Hello every one, I have following data ***CAMPAIGN 1998 CONTRIBUTIONS*** --------------------------------------------------------------------------- NAME PHONE Jan | Feb | Mar | Total Donated ... (12 Replies)
Discussion started by: devmiral
12 Replies

2. UNIX for Dummies Questions & Answers

extracting selected few lines through perl

How can I extract few lines(like 10 to 15, top 10 and last 10) from a file using perl. I do it with sed, head and tail in unix scripting. I am new to perl. Appreciate your help. (2 Replies)
Discussion started by: paruthiveeran
2 Replies

3. UNIX for Dummies Questions & Answers

Awk search for max and min field values

hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value. BEGIN {FS=","; max=0} NF == 7 {if (max < $6) max = $6;} END { print man, min} where $6 is the column of a field separated by a comma (3 Replies)
Discussion started by: Kirichiko
3 Replies

4. UNIX for Dummies Questions & Answers

Iterate a min/max awk script over time-series temperature data

I'm trying to iterate a UNIX awk script that returns min/max temperature data for each day from a monthly weather data file (01_weath.dat). The temperature data is held in $5. The temps are reported each minute so each day contains 1440 temperature enteries. The below code has gotten me as far as... (5 Replies)
Discussion started by: jgourley
5 Replies

5. Shell Programming and Scripting

trying to print selected fields of selected lines by AWK

I am trying to print 1st, 2nd, 13th and 14th fields of a file of line numbers from 29 to 10029. I dont know how to put this in one code. Currently I am removing the selected lines by awk 'NR==29,NR==10029' File1 > File2 and then doing awk '{print $1, $2, $13, $14}' File2 > File3 Can... (3 Replies)
Discussion started by: ananyob
3 Replies

6. UNIX for Dummies Questions & Answers

[Solved] Print a line using a max and a min values of different columns

Hi guys, I already search on the forum but i can't solve this on my own. I have a lot of files like this: And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in... (4 Replies)
Discussion started by: MetaBolic0
4 Replies

7. Shell Programming and Scripting

Get the min avg and max with awk

aaa: 3 ms aaa: 2 ms aaa: 5 ms aaa: 10 ms .......... to get the 3 2 5 10 ...'s min avg and max something like min: 2 ms avg: 5 ms max: 10 ms (2 Replies)
Discussion started by: yanglei_fage
2 Replies

8. Shell Programming and Scripting

awk script to find min and max value

I need to find the max/min of columns 1 and 2 of a 2 column file what contains the special character ">". I know that this will find the max value of column 1. awk 'BEGIN {max = 0} {if ($1>max) max=$1} END {print max}' input.file But what if I needed to ignore special characters in the... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

9. Shell Programming and Scripting

How to get min and max values using awk?

Hi, I need your kind help to get min and max values from file based on value in $5 . File1 SP12.3 stc 2240806 2240808 + ID1_N003 ID2_N003T0 SP12.3 sto 2241682 2241684 + ID1_N003 ID2_N003T0 SP12.3 XE 2239943 2240011 + ID1_N003 ID2_N003T0 SP12.3 XE 2240077 2241254 + ID1_N003 ... (12 Replies)
Discussion started by: redse171
12 Replies

10. Shell Programming and Scripting

awk Sort 2d histogram output from min(X,Y) to max(X,Y)

I've got Gnuplot-format 2D histogram data output which looks as follows. 6.5 -1.25 10.2804 6.5404 -1.25 10.4907 6.58081 -1.25 10.8087 6.62121 -1.25 10.4686 6.66162 -1.25 10.506 6.70202 -1.25 10.3084 6.74242 -1.25 9.68256 6.78283 -1.25 9.41229 6.82323 -1.25 9.43078 6.86364 -1.25 9.62408... (1 Reply)
Discussion started by: chrisjorg
1 Replies

LEARN ABOUT DEBIAN

www::mechanize::formfiller::value::random::date

WWW::Mechanize::FormFiller::Value::Random::Date(3pm)	User Contributed Perl Documentation   WWW::Mechanize::FormFiller::Value::Random::Date(3pm)

NAME

       WWW::Mechanize::FormFiller::Value::Random::Date - Fill a timestamp into an HTML form field

SYNOPSIS

	 use WWW::Mechanize::FormFiller;
	 use WWW::Mechanize::FormFiller::Value::Random::Date;

	 my $f = WWW::Mechanize::FormFiller->new();

	 # Create a random value for the HTML field "born"

	 my $born = WWW::Mechanize::FormFiller::Value::Random::Date->new(
	   born => string => '%Y%m%d', min => '20000101', max => '20373112' );
	 $f->add_value( born => $born );

	 # Alternatively take the following shorthand, which adds the
	 # field to the list as well :

	 # If there is no password, put a random one out of the list there
	 my $last_here = $f->add_filler( last_here => Random::Date => string => '%H%M%S', min => '000000', max => 'now');

DESCRIPTION

       This class provides a way to write a randomly chosen value into a HTML field.

       new NAME, %ARGS
	   Creates a new value which will correspond to the HTML field "NAME". The allowed %ARGS are

	     string => POSIX strftime string
	     min    => minimum time stamp (inclusive)
	     max    => maximum time stamp (exclusive)

	   The "min" and "max" time stamps must be in the same format as the "string" supplies.

	   WARNING

	   The algorithm to implement "min" and "max" barriers is very simplicistic - it tries as many random values as necessary to meet the two
	   criteria. This means that your script may enter an infinite loop if the criteria can never be attained or are too little apart.

       name [NEWNAME]
	   Gets and sets the name of the HTML field this value corresponds to.

       value FIELD
	   Returns the value to put into the HTML field.

   EXPORT
       None by default.

   COPYRIGHT AND LICENSE
       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       Copyright (C) 2002,2003 Max Maischein

AUTHOR

       Max Maischein, <corion@cpan.org>

       Please contact me if you find bugs or otherwise improve the module. More tests are also very welcome !

SEE ALSO

       Data::Random, WWW::Mechanize, WWW::Mechanize::Shell, WWW::Mechanize::FormFiller, WWW::Mechanize::FormFiller::Value::Value,
       WWW::Mechanize::FormFiller::Value::Default, WWW::Mechanize::FormFiller::Value::Fixed, WWW::Mechanize::FormFiller::Value::Interactive

perl v5.10.1							    2009-04-24		      WWW::Mechanize::FormFiller::Value::Random::Date(3pm)
All times are GMT -4. The time now is 10:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy