Sponsored Content
Top Forums Shell Programming and Scripting awk command: column operations Post 302447540 by shashi792 on Monday 23rd of August 2010 01:08:02 PM
Old 08-23-2010
awk command: column operations

I have a txt file with two columns

Code:
Freq    Loss
10         30
20         40
30         10
40         50
50         60

i have used the below code to get the minimum value out of this array in second cloumn.

Code:
awk 'NR==N{min=$N;max=$N}NR>N{if ($N>max){max=$N};if ($N<min){min=$N}}END {print ""min" "max}' $dummyfile.arr

my code finds out the minimum in second coulmn, but

1) I want to get correcponding Freq for tht minimum value

---------- Post updated at 12:08 PM ---------- Previous update was at 12:06 PM ----------

I want to output that freq to a txt file
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

command for a series of operations

I want to append a file containing a list of names and the sorted contents of the file should be copied to a new file. All this should be on a single line( using pipes and redirection) Pls help .. thankyou (1 Reply)
Discussion started by: phiber_optik
1 Replies

2. Shell Programming and Scripting

Masking a column using awk command

Thanks...It was a spoiler for my Team... (5 Replies)
Discussion started by: Diggi
5 Replies

3. Shell Programming and Scripting

Help With Array Operations in AWK

I have two files file1 A 2 4 6 8 B 1 3 5 7 C 1 3 5 7 D 1 3 5 7 E 1 3 5 7 file2 C D E F G H I J K L I need to add field 1 of file1 to both field 2s of file2 and repeat the same on all the rows in... (2 Replies)
Discussion started by: cold_Que
2 Replies

4. Shell Programming and Scripting

awk command - column merging

I have two files having 3 coulms and 1 column respectively file1.txt 0 22.89 35.60 10 22.80 35.61 20 22.70 35.63 30 22.32 35.68 50 19.23 35.79 75 16.10 35.59 100 15.00 35.52 125 14.45 35.46 150 13.91 35.41 200 12.94 35.28 ... (7 Replies)
Discussion started by: shashi792
7 Replies

5. UNIX for Dummies Questions & Answers

arithmetic operations on 1 column of a file

Hi, I have a file with thousands of lines like this: Chr1 477515 . ACCCC ACCC 17.7 . INDEL;DP=17;AF1=1;CI95=0.5,1;DP4=0,1,0,3;MQ=32;PV4=1,0.036,1,1 Chr1 481987 . A AAAT 62 . INDEL;DP=11;AF1=1;CI95=0.5,1;DP4=0,0,1,3;MQ=41 I want to make a file with... (2 Replies)
Discussion started by: fadista
2 Replies

6. Shell Programming and Scripting

how to do arithmetic operations in one line command

I have a file like this product qty1 qty2 value cola 50 25 1 pepsi 100 75 2 muffin 25 30 0.5 would like to do the following operations with one line command 1) disply the line having "Qty1" greater than or equal to 50 2) display the line Qty1 - Qty2 ... (2 Replies)
Discussion started by: johnveslin
2 Replies

7. Shell Programming and Scripting

Arthmetic & Operations Using AWK

Trying to do math while using awk and if statements. awk 'BEGIN {FS = ":"} ; {if($2=1) {$3 +=}; print "Total employee work hours: " $3}' works_on.txt The file format is 123456789:1:32.5 123456789:2:7.5 666884444:3:40.0 453453453:1:20.0 453453453:2:20.0 333445555:2:10.0 ... (6 Replies)
Discussion started by: Rapcher
6 Replies

8. Shell Programming and Scripting

awk command to print only selected rows in a particular column specified by column name

Dear All, I have a data file input.csv like below. (Only five column shown here for example.) Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 3,2,4,5,6 5,3,5,5,6 From this I want the below output Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies

9. Shell Programming and Scripting

How to Replace the value of a column using awk command?

Hi cat test.txt H|123|341|567|asfg D|dfg|trtyy|errt D|ert|frty|wer Here I need to replace the third column value with 100 of the first record only and while printing I need to print the full file content also..I am expecting a result like this H|123|100|567|asfg D|dfg|trtyy|errt... (3 Replies)
Discussion started by: saj
3 Replies

10. Shell Programming and Scripting

Mathematical Operations on Column

Hi All, I want to perform a mathematical operation on column. Can anyone please help? Here is the sample of operation to be performed: 123 996 100 123 996 200 123 996 200 2015-09-21 123 996 100 123 996 200 123 996 100 What I want is to multiple all values of column # 3 by 100 and... (3 Replies)
Discussion started by: Zaib
3 Replies
MAX(3)									 1								    MAX(3)

max - Find highest value

SYNOPSIS
mixed max (array $values) DESCRIPTION
mixed max (mixed $value1, mixed $value2, [mixed $...]) If the first and only parameter is an array, max(3) returns the highest value in that array. If at least two parameters are provided, max(3) returns the biggest of these values. Note Values of different types will be compared using the standard comparison rules. For instance, a non-numeric string will be com- pared to an integer as though it were 0, but multiple string values will be compared alphanumerically. The actual value returned will be of the original type with no conversion applied. PARAMETERS
o $values - An array containing the values. o $value1 - Any comparable value. o $value2 - Any comparable value. o $... - Any comparable value. RETURN VALUES
max(3) returns the parameter value considered "highest" according to standard comparisons. If multiple values of different types evaluate as equal (e.g. 0 and 'abc') the first provided to the function will be returned. EXAMPLES
Example #1 Example uses of max(3) <?php echo max(2, 3, 1, 6, 7); // 7 echo max(array(2, 4, 5)); // 5 // The string 'hello' when compared to an int is treated as 0 // Since the two values are equal, the order they are provided determines the result echo max(0, 'hello'); // 0 echo max('hello', 0); // hello // Here we are comparing -1 < 0, so 'hello' is the highest value echo max('hello', -1); // hello // With multiple arrays of different lengths, max returns the longest $val = max(array(2, 2, 2), array(1, 1, 1, 1)); // array(1, 1, 1, 1) // Multiple arrays of the same length are compared from left to right // so in our example: 2 == 2, but 5 > 4 $val = max(array(2, 4, 8), array(2, 5, 1)); // array(2, 5, 1) // If both an array and non-array are given, the array will be returned // as comparisons treat arrays as greater than any other value $val = max('string', array(2, 5, 7), 42); // array(2, 5, 7) // If one argument is NULL or a boolean, it will be compared against // other values using the rule FALSE < TRUE regardless of the other types involved // In the below example, -10 is treated as TRUE in the comparison $val = max(-10, FALSE); // -10 // 0, on the other hand, is treated as FALSE, so is "lower than" TRUE $val = max(0, TRUE); // TRUE ?> SEE ALSO
min(3), count(3). PHP Documentation Group MAX(3)
All times are GMT -4. The time now is 06:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy