Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Calc max of a column
Top Forums Shell Programming and Scripting Calc max of a column Post 302408854 by alister on Tuesday 30th of March 2010 04:48:07 PM
Old 03-30-2010
Quote:
Originally Posted by rafazz
Iam getting the content from file.sh
nameSmilierice
Ronaldo:5800
Figo:4000
Rafael:2321
Kaka:1230

I write this..

while read name price
do
[[ "$price" -ge "${MAX}" ]] && MAX=$price
done <$price
echo "Max value = $MAX" ;

The error..

./file.sh: line 29: $price: ambiguous redirect
Look at durden_tyler's code more closely. It sets IFS to the value necessary to properly split the lines with read. It looks like you omitted the IFS modification. If so, without any whitespace in the line, the entire line (sans leading whitespace) will be assigned to $name. $price will be empty.

Also, as he mentioned above, you're trying to redirect from the wrong place. $price does not contain the name of the file to read.

Regards,
Alister
Last edited by alister; 03-30-2010 at 05:56 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Max column count in a file

I have to send a file to mainframe and before sending it, I have to execute the quote command to set the record length. Since the file is dynamic, I do not know what the maximum size of a line could be. Currently, I use the following function to get the Max Column Count. Since I use "sed" it... (2 Replies)
Discussion started by: gemini
2 Replies

2. Shell Programming and Scripting

Search max value in a column in a file instead of sort

Hi Everyone, 1.txt 00:00:00 0 0 0 0 0 0 0 00:00:01 0 0 0 2 1 33 2 00:00:02 5 0 0 0 0 0 0 00:00:03 0 4 0 0 0 0 0... (5 Replies)
Discussion started by: jimmy_y
5 Replies

3. Shell Programming and Scripting

loop in awk - column max for each column

Hello all, this should really be easy for you... I need AWK to print column maxima for each column of such input: Input: 1 2 3 1 2 1 1 3 2 1 1 2 Output should be: 2 2 3 3 This does the sum, but i need max instead: { for(i=1; i<=NF; i++) sum +=$i } END {for(i=1; i in sum;... (3 Replies)
Discussion started by: irrevocabile
3 Replies

4. Shell Programming and Scripting

Join and awk max column

Hi Friends, I have a file1 with 3400 records that are tab separated and I have a file2 with 6220 records. I want to merge both these files. I tried using join file1 and file2 after sorting. But, the records should be (3400*6220 = 21148000). Instead, I get only around 11133567. Is there anything... (13 Replies)
Discussion started by: jacobs.smith
13 Replies

5. Shell Programming and Scripting

to find min and max value for each column!

Hello Experts, I have got a txt files which has multiple columns, I want to get the max, min and diff (max-min) for each column in the same txt file. Example: cat file.txt a 1 4 b 2 5 c 3 6 I want ouput like: cat file.txt a 1 4 b 2 5 c 3 6 Max 3 6 Min 1 4 Diff 2 2 awk 'min=="" ||... (4 Replies)
Discussion started by: dixits
4 Replies

6. Shell Programming and Scripting

AWK script to create max value of 3rd column, grouping by first column

Hi, I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column. clientname,day-of-month,max-users ----------------------------------- client1,20120610,5 client2,20120610,2 client3,20120610,7... (3 Replies)
Discussion started by: ckmehta
3 Replies

7. UNIX for Dummies Questions & Answers

get max value every 4 rows between 2 column

Hi all I have a file that has two columns and I need the maximum value in column 2 of 4 positions o rows. for example at position {1..3} there are 4 characters (A, C, G and T) each of these characters with a value with a value in column 2. I need the maximum value in column 2 and the corresponding... (2 Replies)
Discussion started by: xinox
2 Replies

8. Shell Programming and Scripting

Print min and max value from two column

Dear All, I have data like this, input: 1254 10125 1254 10126 1254 10127 1254 10128 1254 10129 1255 10130 1255 10131 1255 10132 1255 10133 1256 10134 1256 10135 1256 10137... (3 Replies)
Discussion started by: aksin
3 Replies

9. Shell Programming and Scripting

Get the MAX value out of a column

I've the following data set. I would like to look at the column 3 and only use the rows which has the max value for column 3 Can we use the awk or sed to achieve it. 10 2 10 100 11 2 20 100 12 2 30 100 13 2 30 100 14 ... (7 Replies)
Discussion started by: rudoraj
7 Replies

10. Shell Programming and Scripting

Get min and max value in column

Gents, I have a big file file like this. 5100010002 5100010004 5100010006 5100010008 5100010010 5100010012 5102010002 5102010004 5102010006 5102010008 5102010010 5102010012 The file is sorted and I would like to find the min and max value, taking in the consideration key1... (3 Replies)
Discussion started by: jiam912
3 Replies

LEARN ABOUT SUNOS

mlib_vectormaximummag_u8c

mlib_VectorMaximumMag_U8C(3MLIB)			    mediaLib Library Functions				  mlib_VectorMaximumMag_U8C(3MLIB)

NAME

       mlib_VectorMaximumMag_U8C,  mlib_VectorMaximumMag_S8C,  mlib_VectorMaximumMag_S16C, mlib_VectorMaximumMag_S32C, mlib_VectorMaximumMag_F32C,
       mlib_VectorMaximumMag_D64C - find the first element with the maximum magnitude in a vector

SYNOPSIS

       cc [ flag... ] file... -lmlib [ library... ]
       #include <mlib.h>

       mlib_status mlib_VectorMaximumMag_U8C(mlib_u8 *max, const mlib_u8 *x, mlib_s32 n);

       mlib_status mlib_VectorMaximumMag_S8C(mlib_s8 *max, const mlib_s8 *x, mlib_s32 n);

       mlib_status mlib_VectorMaximumMag_S16C(mlib_s16 *max, const mlib_s16 *x, mlib_s32 n);

       mlib_status mlib_VectorMaximumMag_S32C(mlib_s32 *max, const mlib_s32 *x, mlib_s32 n);

       mlib_status mlib_VectorMaximumMag_F32C(mlib_f32 *max, const mlib_f32 *x, mlib_s32 n);

       mlib_status mlib_VectorMaximumMag_D64C(mlib_d64 *max, const mlib_d64 *x, mlib_s32 n);

DESCRIPTION

       Each of these functions finds the first element with the maximum magnitude in a complex vector, then puts the real and imaginary  parts	of
       it into max[0] and max[1], respectively.

PARAMETERS

       Each of the functions takes the following arguments:

       max	       Pointer to the first element with the maximum magnitude.

       x	       Pointer to the first element of the source vector.

       n	       Number of elements in the source vector.

RETURN VALUES

       Each of the functions returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Evolving			   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mlib_VectorMinimumMag_U8C(3MLIB), mlib_MatrixMaximumMag_U8C(3MLIB), mlib_MatrixMinimumMag_U8C(3MLIB), attributes(5)

SunOS 5.10							    9 Nov 2004					  mlib_VectorMaximumMag_U8C(3MLIB)
All times are GMT -4. The time now is 05:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy