Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find Max value of line and print
Top Forums Shell Programming and Scripting Find Max value of line and print Post 302966369 by ncwxpanther on Thursday 11th of February 2016 09:21:19 AM
Old 02-11-2016
I have the following code set up to analyze several thousand files is multiple directories. The result output is only a single max out of all $file per $dir.

I am expecting a max value for each of the $file for each $dir to be returned.

What am I missing?


Code:
#!/bin/bash

for dir in a b c x y z
do

for file in USW*
do
awk '
BEGIN   {MAX=-1E100
        }
        {for (x=2; x<=NF; x++) if ($x>MAX)      {MAX = $x
                                                 C1  = $1
                                                }
        }
END     {print substr(C1,1,11), substr(C1,13,4), substr(C1,18,2), substr(C1,20,8), MAX
        }
' /dir/of/files/$dir/$file
done

done

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help: Find line where column has max vlaue

Hi all, Ive searched the forum but with no luck... I have a file: ID Name Val 1 bob 45 2 joe 89 3 sue 11 4 steve 89 ... etc I want to find a way to print... (6 Replies)
Discussion started by: muay_tb
6 Replies

2. Shell Programming and Scripting

Perl : Find a string and Print full line

Hi Need a perl script to read lines in a file, scan for a string named "APPLE" and write to different file the only lines containing the matched string. (5 Replies)
Discussion started by: PrasannaKS
5 Replies

3. Shell Programming and Scripting

How to find and print the last word of each line from a text file

Can any one help us in finding the the last word of each line from a text file and print it. eg: 1st --> aaa bbbb cccc dddd eeee ffff ee 2nd --> aab ered er fdf ere ww ww f the o/p should be a below. ee f (1 Reply)
Discussion started by: naveen_sangam
1 Replies

4. Shell Programming and Scripting

awk find a string, print the line 2 lines below it

I am parsing a nagios config, searching for a string, and then printing the line 2 lines later (the "members" string). Here's the data: define hostgroup{ hostgroup_name chat-dev alias chat-dev members thisisahostname } define hostgroup{ ... (1 Reply)
Discussion started by: mglenney
1 Replies

5. Shell Programming and Scripting

Find a string using grep & print the line above or below that.

Hi All, Please tell me how can I Find a string using grep & print the line above or below that in solaris? Please share as I am unable to use grep -A or grep -B as it is not working on Solaris. (10 Replies)
Discussion started by: Zaib
10 Replies

6. UNIX for Dummies Questions & Answers

loop? print max column in each line for 800 files and merge

Hello, I have 800 or so files with 3 columns each and >10000 lines each. For each file and each line I would like to print the maximum column number for each line. Then I would like to 'paste' each of these files together (column-wise) so that the file with expression in label '_1' is the... (6 Replies)
Discussion started by: peanuts48
6 Replies

7. 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

8. Shell Programming and Scripting

Find 2 expressions then print in a single line

Guys, need help. I have a file that contains something like this: abc def ghi jkl I want to print the first and last line of the file and the output should be in a single line. so, output should be like this: abc jkl (3 Replies)
Discussion started by: solidhelix08
3 Replies

9. UNIX for Dummies Questions & Answers

Using awk to find max and printing entire line

Hi folks, I am very new to awk. I have what is probably a very simple question. I'm trying to get the max value of column 1, but also print column 2. My data looks like this: 0.044|2000-02-03 14:00:00 5.23|2000-02-03 05:45:00 5.26|2000-02-03 11:15:00 0|2000-02-01 18:30:00 So in this case... (2 Replies)
Discussion started by: amandarobe
2 Replies

10. Shell Programming and Scripting

Find line then evaluate text on next line, print when condition is met

Hello, I am looking for a specific situation in a text file. The conditions are, > <CompoundName> InChI=1S/C5H12NO2/c1-5(2)4-8-6(3)7/h5H,4H2,1-3H3/q+1 I am looking for cases where the line "> <CompoundName>" is followed by a line that contains the string "InChI=" without regard to... (5 Replies)
Discussion started by: LMHmedchem
5 Replies

LEARN ABOUT DEBIAN

unburden-home-dir

UNBURDEN-HOME-DIR(1)						   User Commands					      UNBURDEN-HOME-DIR(1)

NAME

       unburden-home-dir - unburdens home directories from caches and trashes

SYNOPSIS

       unburden-home-dir [ -n | -u | -f filter ]
       unburden-home-dir ( -h | --help | --version )

DESCRIPTION

       unburden-home-dir  unburdens  the  home	directory from files and directory which cause high I/O or disk usage but are neither important if
       they are lost, e.g. caches or trash directory.

       When being run it moves the files and directories given in the configuration file to a location outside the home directory,  e.g.  /tmp	or
       /scratch, and puts appropriate symbolic links in the home directory instead.

OPTIONS

       -f     just  unburden those directory matched by the given filter (a perl regular expression) -- matches the already unburdened directories
	      if used together with -u.

       -F     Do not check for files in use with lsof before (re)moving files.

       -n     dry run (show what would be done)

       -u     undo (reverse the functionality and put stuff back into the home directory)

       -h, --help
	      show this help

       --version
	      show the program's version

EXAMPLES

       Example configuration files can be found at /usr/share/doc/unburden-home-dir/examples on Debian-based systems and in the etc/ directory	of
       the source tar ball.

FILES

       /etc/unburden-home-dir,	 /etc/unburden-home-dir.list,	~/.unburden-home-dir,  ~/.unburden-home-dir.list,  /etc/default/unburden-home-dir,
       /etc/X11/Xsession.d/95unburden-home-dir

       Read /usr/share/doc/unburden-home-dir/README on debianoid installations or README in the source tar ball for an explanation of these files.

SEE ALSO

       corekeeper (http://openvswitch.org/cgi-bin/gitweb.cgi?p=corekeeper), autotrash(1), agedu(1), bleachbit(1).

       For du(1)-like but more comfortable tools, see ncdu(1) (text-mode), baobab(1) (GNOME), filelight(1) (KDE), xdiskusage(1)  (X  tool  calling
       du(1) itself), or xdu(1) (X tool reading du(1) output from STDIN).

AUTHOR

       Unburden Home Dir is written and maintained by Axel Beckert <beckert@phys.ethz.ch>

LICENSE

       Unburden Home Dir is available under the terms of the GNU General Public License (GPL) version 2 or any later version at your option.

Unburden Home Directory 					     May 2012						      UNBURDEN-HOME-DIR(1)
All times are GMT -4. The time now is 08:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy