Sponsored Content
Top Forums Shell Programming and Scripting AWK (how) to get smallest/largest nr of ls -la Post 302412258 by Franklin52 on Monday 12th of April 2010 06:24:47 AM
Old 04-12-2010
Quote:
Originally Posted by abciscool
Thank you so much for you help, if it works it will cover already half of what I wanted to achieve (which is a lot!! Smilie).

To recap, for thought-process:

Code:
NR==2 { min = max = $5}
NR > 2 { if (min > $5) 
            min = $5
            if (max < $5)
            max = $5 }
END {print "Minimum:", min, "Maximum:", max}

If I read it correctly;
At the second record set the variables min and max to the value of the 5th field. Then at every record past the second one do;
- if the min-variable is greater than the value of the 5th field, set the variable min to the current value of the 5th field.
- if the max-variable is smaller than the value of the 5th field, set the variable max to the current value of the 5th field.
At the END print the min- & max- variables current value in the output.

Is my clarification of this code correct, or am I missing some aspects?

- Mario de Rooy

(Thanks again!!)
Mario,

Your assumption is correct.

Regards
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

checking the smallest and largest number

Hi All, My script is reading a log file line by line log file is like ; 19:40:22 :INFO Total time taken to Service External Request---115ms 19:40:25 DEBUG : Batch processed libdaemon.x86_64 0-0.10-5.el5 - u 19:40:22 INFO Total time taken to Service External Request---20ms 19:40:24... (4 Replies)
Discussion started by: subin_bala
4 Replies

2. UNIX for Dummies Questions & Answers

How to print largest and smallest number.

Hey. This is pretty easy stuff but I'm learning the basics of Unix at the moment so keep that in mind. I have to: 1) Write a C-shell script to monitor user activity on the server for 13 minutes. 2) Then print the smallest and largest number of users during these 13 minutes. I have this: 1)... (2 Replies)
Discussion started by: amp10388
2 Replies

3. Shell Programming and Scripting

largest field , awk , help

Hi All, My file is like this: $ cat max.txt abcd:1982:a efghij:1980:e klmn:1923:k opqrst:1982:o I have to find out the largest first field and the corresponding line. i.e Output required: efghij efghij:1980:e opqrst opqrst:1982:o HTH, jkl_jkl (6 Replies)
Discussion started by: jkl_jkl
6 Replies

4. Shell Programming and Scripting

awk second largest, third largest value

I have two text files like this: file1.txt: 133 10 133 22 133 13 133 56 133 78 133 98 file2.txt: 158 38 158 67 158 94 158 17 158 23 I'm basically trying to have awk check the second largest value of the second column of each text file, and cat it to its own text file. There... (13 Replies)
Discussion started by: theawknewbie
13 Replies

5. UNIX for Dummies Questions & Answers

Printf awk: argument to adjust automatically width to the largest value

Hi ! Here is an example of a tab-delimited file with variable width values in field 2 (space separated values). As the real file contains lot of lines, I can adjust manually the width to the largest value in field 2. Does it exist an argument to do it automatically? input.tab:... (4 Replies)
Discussion started by: lucasvs
4 Replies

6. Shell Programming and Scripting

Use a string in one column to get the largest or the smallest of another column

I have data that looks like this: chr1 mm9_knownGene exon 155747075 155747189 0.000000 + . gene_id "Glul"; transcript_id "uc007daq.1"; chr1 mm9_knownGene exon 155750064 155750076 0.000000 + . gene_id "Glul";... (3 Replies)
Discussion started by: pbluescript
3 Replies

7. Shell Programming and Scripting

Find smallest & largest in every column

Dear All, I have input like this, J_15TEST_ASH05_33A22.13885.txt: $$ 1 MAKE SP1501 1 1 4 6101 7392 2 2442 2685 18 3201 4008 20 120 4158 J_15TEST_ASH05_33A22.13885.txt: $$ 1 MAKE SP1502 1 1 4 5125 6416 2 ... (4 Replies)
Discussion started by: attila
4 Replies

8. Shell Programming and Scripting

Find smallest between replicates ID

Hi All I need to find the smallest values between replicates id (column1) Input file: a name1 1200 a name2 800 b name1 100 b name2 150 b name3 4output: a name2 800 b name3 4 Do you have any suggestion? Thank you! (9 Replies)
Discussion started by: giuliangiuseppe
9 Replies

9. Shell Programming and Scripting

Print smallest integer from file using awk custom function?

`awk` function looks like this in a file name `fun.awk`: { print small() } function small() { a=$0 smal=0 for(i=1;i<=3;i++) { if( a<a) smal=a else (4 Replies)
Discussion started by: lazerz
4 Replies

10. Shell Programming and Scripting

awk to combine all matching fields in input but only print line with largest value in specific field

In the below I am trying to use awk to match all the $13 values in input, which is tab-delimited, that are in $1 of gene which is just a single column of text. However only the line with the greatest $9 value in input needs to be printed. So in the example below all the MECP2 and LTBP1... (0 Replies)
Discussion started by: cmccabe
0 Replies
Vend::Ship::Postal(3pm) 				User Contributed Perl Documentation				   Vend::Ship::Postal(3pm)

NAME
Vend::Ship::Postal -- Calculate US Postal service international rates SYNOPSIS
(in catalog.cfg) Database usps ship/usps.txt TAB Database air_pp ship/air_pp.txt TAB Database surf_pp ship/surf_pp.txt TAB (in shipping.asc) air_pp: US Postal Air Parcel crit weight min 0 max 0 cost e No shipping needed! at_least 4 adder 1 aggregate 70 table air_pp min 0 max 1000 cost s Postal min 70 max 9999999 cost e Too heavy for Air Parcel surf_pp: US Postal Surface Parcel crit weight min 0 max 0 cost e No shipping needed! at_least 4 adder 1 aggregate 70 table surf_pp min 0 max 1000 cost s Postal min 70 max 9999999 cost e Too heavy for Postal Parcel DESCRIPTION
Looks up a service zone by country in the "usps" table, then looks in the appropriate rate table for a price by that zone. Can aggregate shipments greater than 70 pounds by assuming you will ship multiple 70-pound packages (plus one package with the remainder). perl v5.14.2 2010-03-25 Vend::Ship::Postal(3pm)
All times are GMT -4. The time now is 11:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy